Return
-
Title
Server side object generated scripts have incomplete SQL statements -
Description
Database | Administer | Server Side Object Wizard | Select "Create setup scripts without a database connection". Open the generated TOADUser.sql. The following SQL statements are missing the user:
GRANT CREATE PUBLIC SYNONYM TO ;
GRANT DROP PUBLIC SYNONYM TO ;
GRANT EXECUTE ANY PROCEDURE TO ;
GRANT CREATE ROLE TO ;Also the TOADProfiler.sql is missing the 'TOAD' entry in the following line:DEFINE OWNER = ''
-
Cause
Product defect
-
Resolution
WORKAROUND
Manually add the user TOAD to complete the SQL grant statement.
Also Edit TOADProfile.sql - DEFINE OWNER = 'TOAD'STATUS
Waiting for fix in a future release of Toad for Oracle.
-
Defect ID
ST81967