Skip to Main Content

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 object privilege for procedure, packages?

karthiksingh_dbaAug 12 2013 — edited Aug 20 2013

Dear Legends,

what is the query to find the Grant Permissions provided to a User on particular object such as Procedure, Package and Function?

DBA_TAB_PRIVS is not giving me the answer.


Can any one help me on this?


Thanks,

Karthik

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 17 2013
Added on Aug 12 2013
16 comments
19,867 views