6.7. Auditing Database Activity

Auditing involves monitoring and recording specific database activity. An Oracle 10g database supports four levels of auditing and affords you two locations for recording these activities.

Real World Scenario: Implementing a Corporate Password Security Policy

Many companies have security policies requiring that several password complexity rules be followed. For your Oracle 10g database, these rules can be incorporated into a password verify function. Here is an example of three password-complexity requirements and how they are satisfied through a password verify function named MY_PASSWORD_VERIFY.

The first rule specifies that the password must be at least six characters in length. The second rule disallows passwords ...

Get OCA: Oracle 10g™ Administration I: Study Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.