Home » RDBMS Server » Security » How check the Audit is enabled for particular schema (10g R2 HP-UX)
How check the Audit is enabled for particular schema [message #539068] Wed, 11 January 2012 04:00 Go to next message
pokhraj_d
Messages: 116
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
Re: How check the Audit is enabled for particular schema [message #539092 is a reply to message #539068] Wed, 11 January 2012 04:56 Go to previous messageGo to next message
Michel Cadot
Messages: 57607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query DBA_OBJ_AUDIT_OPTS and DBA_PRIV_AUDIT_OPTS views.

Regards
Michel
Re: How check the Audit is enabled for particular schema [message #544025 is a reply to message #539092] Sun, 19 February 2012 07:24 Go to previous messageGo to next message
hemant_khandare
Messages: 65
Registered: November 2011
Member

SQL> SHOW PARAMETER AUDIT_trail
Re: How check the Audit is enabled for particular schema [message #544026 is a reply to message #544025] Sun, 19 February 2012 07:24 Go to previous messageGo to next message
hemant_khandare
Messages: 65
Registered: November 2011
Member
If it set to none means its is off
Re: How check the Audit is enabled for particular schema [message #544038 is a reply to message #544026] Sun, 19 February 2012 09:14 Go to previous message
Michel Cadot
Messages: 57607
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Thu Apr 17 16:39:35 CDT 2014

Total time taken to generate the page: 0.06099 seconds