Solved

show parameter audit

Posted on 2014-03-03
1
291 Views
Last Modified: 2014-03-10
can I ask what "db" represents when running the query in the question title, in terms of what, what exactly will be being audited, action wise? I have run this query over a number of databases, so return NONE others DB. I just wondered what kinds of thing will be being audited, with such a configuration?
0
Comment
Question by:pma111
1 Comment
 
LVL 22

Accepted Solution

by:
Steve Wales earned 500 total points
ID: 39901241
You may want to refer to the documentation on this one :)

http://docs.oracle.com/cd/E11882_01/network.112/e36292/auditing.htm#DBSEG352

There are certain standard auditing options that Oracle can undertake that are written to sys.aud$

If you set audit_trail to NONE, these features are disabled.
Setting to DB means that these rows are written to SYS.AUD$
You can also set to OS, which would write the rows to an operating system level file.

There's a lot of stuff that can be captured, so I'd recommend reading that chapter of the documentation and coming back with any specific questions you might have.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

685 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