SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating synonyms using dynamic SQLs across the DATABASE

217886May 27 2005 — edited Jun 1 2005

Here is the situation:

In databse DB_1 there is a procedure PROC_1 created under SCHEMA_1 which creates synonyms under the same schema for some tables and packages (owned by SCHEMA_1) thru' dynamic SQLs.This works fine if execute this procedure under this schema but if I execute the same procedure under SCHEMA_2 in database DB_2 thru' databse link (using a user USER_1 with EXECUTE privilege on PROC_1 in DB_1) it creates synonyms only for tables but for packages.

What I'm missing here?. Is there a specific privilege needs to granted for these users?.

Any help would be appreciated.

Thanks
-Krishnamurthy

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2005

Added on May 27 2005

12 comments

771 views