Oracle auditing


Oracle auditing

<<Previous  Next>>

Session auditing
Statement auditing
Privilege auditing
Object auditing

Oracle Auditing - Feb 14, 2009 at 15:00 PM by Amit Satpute

Session auditing

Auditing can be for an individual user at session level or access level.

At access level a single record is created per action and at session level one record is created for all audit actions per session.

Session audit records all distinct Encryption and Decryption requests for all sessions.

Session Auditing allows viewing who has had access to your encrypted data down to the Terminal ID and database column level.

The Encryption Wizard management reports to trace user activity against the encrypted data.

Statement auditing

Auditing powerful system privileges without regard to specifically named objects is called statement auditing.

Privilege auditing

Auditing the use of powerful system privileges without regard to specifically named objects is called privilege auditing.

Object auditing

Auditing accesses to specific schema objects without regard to user is called Object auditing.
Also read
Oracle database tuning

Automatic Performance Diagnostic and Tuning Features, Automatic Shared Memory Management - Automatic Shared Memory Management puts Oracle in control of allocating memory within the SGA..........

Difference between post database commit & post-form commit

Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts.............

Oracle error handling

What is Exception in Oracle?, What are the predefined oracle exceptions?, Explain user defined exceptions in oracle, How PL/SQL Exceptions Are Raised?.............

How are extents allocated to a segment?

An extent is stored some specific information. This information is stored using specific number of adjoining data blocks. A collection of extent is called as a segment stored in the same tablespace.............

Oracle Modernization Solutions

A lot has been written on legacy modernization in the past few years. Most of the books, analyst reports, and white papers discuss at a high level why one should modernize and theorize, and the different approaches to, and possible outcomes of modernization............

<<Previous  Next>>

Write your comment - Share Knowledge and Experience


Interview questions
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring