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!

How to check synonyms created properly?

AnupSep 3 2011 — edited Sep 4 2011

Hi Experts,

I have two schemas:
*(a) Owner Schema* - Which contains all the Tables.
*(b) User Schema* - Which doesnot contain any Tables. From this User Schema the Users can only do select, insert, update, delete operations on all the Tables of the Owner Schema. I have created the Public synonyms to the User Schema.

Now I want to check if all the grants, synonyms are created properly or not.

Can we have a script to test all the synonyms, once they are created. Any suggestions would be helpful.

Thanks in Advance!

~Anup

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2011

Added on Sep 3 2011

3 comments

473 views