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
Automatic Performance Diagnostic and Tuning Features, Automatic Shared Memory
Management - Automatic Shared Memory Management puts Oracle in control of
allocating memory within the SGA..........
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.............
What is Exception in Oracle?, What are the predefined oracle exceptions?,
Explain user defined exceptions in oracle, How PL/SQL Exceptions Are
Raised?.............
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.............
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............
|
