Oracle Database Discussions

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!

check invalid synonym for procedure and packages

62603Aug 23 2004 — edited Aug 26 2004

Hi All,

I have two schema object schema and basic schema object schema contains all the objects and basic schema has all the synonyms and grants.

now I want to check if all the synonyms are valid for the packages and procedure in the basic schema and has execute privilege on.

As a dba or basic user.

How can I do that ?

Can somebody Enlighten me How can I do that.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 23 2004

Added on Aug 23 2004

#general-database-discussions

2 comments

400 views