"Anton Buijs" <remove_aammbuijs_at_xs4all.nl> wrote in message
news:3f12f7e5$0$49098$e4fe514c_at_news.xs4all.nl...
>
> 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.
>
Make a hierarchical query, using START WITH...CONNECT BY. Check the SQL
reference for that one.
Or write a procedure...
Or a script.
Herman
Received on Mon Jul 14 2003 - 16:46:07 CDT
