Toad World Blog

Make Code Tester available to a specific schema (private synonyms)

Oct 24, 2017 10:38:00 AM by Quest Software

Use the scripts in the linked file to grant access to Code Tester from a specific schema, and to create private synonyms on Code Tester objects in that schema. 

These scripts avoid the need to create public synonyms, while still allowing you to work with a single, shared Code Tester repository.

qu_grant_execute.sql - connect into Code Tester schema and run script, passing the "target" schema as the parameter to the script.

qu_private_synonyms.sql - connect into "target" schema and run the script, and run script, passing the Code Tester schema as the parameter to the script.

A future release will incorporate these scripts into the tool itself.

private_synonyms.zip

Tags: Toad for Oracle Code Tester for Oracle Samples

Quest Software

Written by Quest Software