Solved

audir related SQL

Posted on 2014-02-19
2
238 Views
Last Modified: 2014-02-20
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
Comment
Question by:pma111
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 12

Accepted Solution

by:
Praveen Kumar Chandrashekatr earned 250 total points
ID: 39870044
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
 
LVL 28

Assisted Solution

by:Naveen Kumar
Naveen Kumar earned 250 total points
ID: 39872173
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
dbms_crypto.decrypt   errors out 6 61
Help with Oracle IF statment 5 50
Errror when importing data from Oracle to SQL 6 67
Automate an Oracle update in Excel 7 70
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to take different types of Oracle backups using RMAN.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question