Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 273
  • Last Modified:

audir related SQL

are there any useful SQL queries that can determine what audit settings are enabled for an oracle database? i.e. is auditing turned on, if yes, what events are being audited etc.
0
pma111
Asked:
pma111
2 Solutions
 
Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
check the parameter audit_trial setting in the DB if it is set to none its disabled.

$export ORACLE_SID=<SID>
$sqlplus "/as sysdba"
SQL>show parameter audit;

check this document for more details.
http://www.oracle-base.com/articles/10g/auditing-10gr2.php
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
you can also use the below query to check the audit parameters/values.

select *
from v$parameter
where name like '%aud%'

Thanks,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now