Re: what is being audited by the database

Why do you have "where USER_NAME is not null" if you want to see all audit rules in effect?

What full version of Oracle is this?

Is Unified Auditing in use?

Mark Powell
Database Administration
(313) 592-5148

USERHOST:[7] "curve2"
TERMINAL:[7] "unknown"
ACTION:[1] "3"

SELECT * FROM DBA_STMT_AUDIT_OPTS where USER_NAME is not null order by user_name,audit_option;
SELECT * FROM DBA_PRIV_AUDIT_OPTS where USER_NAME is not null order by user_name,privilege;
SELECT * FROM DBA_OBJ_AUDIT_OPTS order by owner,object_name,object_type;
SELECT * FROM ALL_DEF_AUDIT_OPTS;

All of them return cero rows except ALL_DEF_AUDIT_OPTS which shows

ALT AUD COM DEL GRA IND INS LOC REN SEL UPD REF EXE FBK REA --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/-

Anyone know where else can I check :-?

audit parameters

show parameter audit

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                      string      /u01/app/oracle/admin/AIX112/adump
audit_sys_operations                 boolean     FALSE
audit_syslog_level                   string      LOCAL6.NOTICE
audit_trail                          string      OS

Thank you

DXC Technology Company - Headquarters: 1775 Tysons Boulevard, Tysons, Virginia 22102, USA. DXC Technology Company -- This message is transmitted to you by or on behalf of DXC Technology Company or one of its affiliates. It is intended exclusively for the addressee. The substance of this message, along with any attachments, may contain proprietary, confidential or privileged information or information that is otherwise legally exempt from disclosure. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate any part of this message. If you have received this message in error, please destroy and delete all copies and notify the sender by return e-mail. Regardless of content, this e-mail shall not operate to bind DXC Technology Company or any of its affiliates to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose. --.

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