Oracle: object privileges

Feature requests and their debate

Oracle: object privileges

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

sandman42
 
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.
Serge
 
Posts: 1526
Joined: Sat Feb 26, 2011 8:24 pm
Location: SPb


Return to Feature Requests



Who is online

Users browsing this forum: No registered users and 9 guests