SQL Developer

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!

grant checking for synonyms

mafaizJul 20 2011 — edited Jul 20 2011

Hi,
I have an schema as "SCOTT" in testdb
I use the following syntax to get object_name and object_type

select object_name,object_type from user_objects ;
Total i got 30 synonyms objects,20 views, and 10packages.

Her i just want to know that how do i get owner of the object,grant permission provided for the particular synonyms(synonym_name),views,or packages.

Thanks in advance

Regards
Faiz

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2011

Added on Jul 20 2011

#sql-developer

2 comments

3,117 views