RE: Table dba_role_privs; Column admin_option

One can back me up so you have a second.  

User Y will keep their privileges. If you had granted General with the 'grant option' instead, then they would not.  

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72546
904 727-2546

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sam Bootsma Sent: Thursday, November 08, 2007 2:50 PM To: oracle-l_at_freelists.org
Subject: Table dba_role_privs; Column admin_option  

Hello Everybody,  

I have a user GENERAL that has admin_option equals "yes" on a couple of roles. I do not know if user GENERAL has granted these roles to another user Y, or not. If I revoke privileges on these roles from GENERAL, then what happens to user Y's role privileges? Would they revoked at the same time? If yes, is there a way to determine ahead of time which users have been granted their roles from GENERAL?  

I know that dba_tab_privs has a "grantor" column that shows who granted the table privilege, but I haven't seen anything similar for role privileges.  

Thanks very much for your assistance.    

Sam Bootsma

Oracle Database Administrator

Information Technology Services
George Brown College

Phone: 416-415-5000 x4933
Fax: 416-415-4836
E-mail: sbootsma_at_georgebrown.ca <mailto:sbootsma_at_georgebrown.ca>  

--
http://www.freelists.org/webpage/oracle-l