Oracle: object privileges

Feature requests and their debate

Oracle: object privileges

Postby sandman42 » Thu Oct 20, 2011 9:07 am

Posts: 14
Joined: Wed Oct 12, 2011 8:31 am

Re: Oracle: object privileges

Postby Serge » Fri Oct 21, 2011 8:28 am

Current version support browse of Users, Roles and their privileges (but this feature is available only if you are database admin, i.e. you have DBA role).

Or do you mean object priveleges from object's side? I.e. to be able to see who has permissions on certain object (table, package, etc)?

BTW USER_TAB_PRIVS contains privileges only for current user, so we use ALL_*_PRIVS tables to get more info. From the other hand some ALL_ tables are accessible only for administrators.
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb

Return to Feature Requests

Who is online

Users browsing this forum: Google [Bot] and 6 guests