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!

Get grant details on synonymsin 11gR2

907035Feb 17 2014 — edited Feb 19 2014

Hi,

I want to get the grants data, on the synonyms and on Objects, I tried look into dictinary views but I couldnt get it.

For Example Select * from user_tab_privs; will give the grants on table, but I want the grants given to View,Procs,Synonyms.

Im on 11gR2

Please help.

Kind Regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 19 2014

Added on Feb 17 2014

#11gr2, #general-database-discussions, #on

12 comments

1,050 views