Re: system privilege

Pete Finnigan <pete_at_petefinnigan.com> schreef in berichtnieuws wv70oBBj2tE$EwxW_at_peterfinnigan.demon.co.uk...
| Hi Jenny
|
| Try:
|
| SQL> col grantee for a20
| SQL> col privilege for a15
| SQL> col admin_option for a4
| SQL> select grantee,privilege,admin_option
| 2 from dba_sys_privs
| 3 where privilege like '%AUDIT%';
|
| GRANTEE PRIVILEGE ADMI
| -------------------- --------------- ----
| CTXSYS AUDIT ANY NO
| CTXSYS AUDIT SYSTEM NO
| DBA AUDIT ANY YES
| DBA AUDIT SYSTEM YES
| IMP_FULL_DATABASE AUDIT ANY NO
| MDSYS AUDIT ANY YES
| MDSYS AUDIT SYSTEM YES
|
| 7 rows selected.
|
| SQL>
|
| Script is also on my tools page http://www.petefinnigan.com/tools.htm
|
| hth
|
| kind regards
|
| Pete
| --
| Pete Finnigan
| email:pete_at_petefinnigan.com
| Web site: http://www.petefinnigan.com - Oracle security audit specialists
| Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.

And how do you query the sysprivs you have based on a granted role? And how do you query the sysprivs you have based on a role granted to a role granted to you?
And the sysprivs based on a role granted to a role granted on a role granted to you?
And remove the duplicates. And I want to know which role gave me the priv. Received on Mon Jul 14 2003 - 13:35:44 CDT