• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1283
  • Last Modified:

Oracle object permissions

If i need to find the roles/users who have permission to execute a particular procedure/package , or read/update a particular table,which data dictionary object should i query.
thanks in advance.
0
ranadhir
Asked:
ranadhir
1 Solution
 
baonguyen1Commented:
Those views may help:

ALL_TAB_PRIVS
USER_TAB_PRIVS
DBA_TAB_PRIVS
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now