Public Synonym - Insufficient privileges

[rshivagami]

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.

[amar]

GRANT the user "CREATE PUBLIC SYNONYM" Priv before executing the procedure.

-amar

[sathya1212]

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