OraFAQ Forum: Security » How check the Audit is enabled for particular schema

Home » RDBMS Server » Security » How check the Audit is enabled for particular schema (10g R2 HP-UX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How check the Audit is enabled for particular schema [message #539068]

Wed, 11 January 2012 04:00

pokhraj_d
Messages: 117
Registered: December 2007

Senior Member

Hi All,

Can anyone suggest how to check that audit is enabled for any particular schema.
The below is my audit parameter from database level:-

SQL>SHOW PARAMETER AUDIT

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /db17/dbdump/xxxx/adump
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string DB_EXTENDED

Thanks-
P

Report message to a moderator

Re: How check the Audit is enabled for particular schema [message #539092 is a reply to message #539068]

Wed, 11 January 2012 04:56

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Query DBA_OBJ_AUDIT_OPTS and DBA_PRIV_AUDIT_OPTS views.

Regards
Michel

Report message to a moderator

Re: How check the Audit is enabled for particular schema [message #544025 is a reply to message #539092]

Sun, 19 February 2012 07:24

hemant_khandare
Messages: 72
Registered: November 2011

Member

SQL> SHOW PARAMETER AUDIT_trail

Report message to a moderator

Re: How check the Audit is enabled for particular schema [message #544026 is a reply to message #544025]

Sun, 19 February 2012 07:24

hemant_khandare
Messages: 72
Registered: November 2011

Member

If it set to none means its is off

Report message to a moderator

Re: How check the Audit is enabled for particular schema [message #544038 is a reply to message #544026]

Sun, 19 February 2012 09:14

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And if you read the topic you'd see OP has already posted it.

Regards
Michel

[Updated on: Sun, 19 February 2012 09:16]

Report message to a moderator

Previous Topic:	Oracle Login Fail
Next Topic:	Create Passwordfile In Oracle 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 21:40:18 CST 2025