Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • 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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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