Re: system privilege

From: Pete Finnigan <pete_at_petefinnigan.com>
Date: Mon, 14 Jul 2003 17:43:15 +0100
Message-ID: <wv70oBBj2tE$EwxW@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.

Received on Mon Jul 14 2003 - 11:43:15 CDT