-
Using this procedure, I generated the 'Create Public Synonym ....' statements for all the tables and then used them individually to generate the synonyms - without using the 'Execute Immediate..'. My work is done - in a indirect way - but if anyone can think of anything that we may have missed here, I would surely like to know about it.
Thanks for all your help.
Shiva.
-
GRANT the user "CREATE PUBLIC SYNONYM" Priv before executing the procedure.
-amar
-
HI.........
U HAVE TO GRANT CREATE PUBLIC SYNONYM TO THE USER EXECUTING THE PROCEDURE.ONLY THEN HE CAN CREATE A PUBLIC SYNONYM.CREATE ANY SYNONYM PRIV. WILL NOT ALLOW TO CREATE PUBLIC SYNONYM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|