Herman Rollfs of Roelofs <roelofs223_at_zonnet.nl> schreef in berichtnieuws
zwFQa.5979$w3.1697445_at_zonnet-reader-1...
| "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
|
|
Herman, correct answer,
My first intention was to make clear that Pete's script is not the complete
answer.
My second intention was to be lazy this time and persue the group to post
such a script. I have thought about it and it is not so easy to find "the
best" solution. Can take some time to make it.
Received on Mon Jul 14 2003 - 17:11:21 CDT
