DBA_OBJ_AUDIT_OPTS Auditing options in effect for database objects.
DBA_PRIV_AUDIT_OPTS Auditing options in effect for system privileges.
DBA_STMT_AUDIT_OPTS Auditing options in effect for statements.
TABLE 9-20 Auditing-Related Data Dictionary Views
Chapter 9: Database Security and Auditing 341
information, compliance requirements such as those defined in the Sarbanes-Oxley act
require strict monitoring of all business operations, including security-related operations
in the database.
You can use DBCA to configure default auditing either when you create a database or after
the database is already created. Using DBCA to configure default auditing after a database has
already been created is useful if you??™ve changed many of your auditing settings and want to reset
auditing options to baseline values.
In addition to setting the value of the initialization parameter AUDIT_TRAIL to DB, the
default auditing settings audit the audit role command itself. In addition, you can see the
privileges audited by default in the Oracle Enterprise Manager Audit Settings page on the Audited
Privileges tab; Figure 9-9 shows the default audited privileges plus two others created earlier in
this chapter.
FIGURE 9-9 Displaying audited privileges using OEM
342 Oracle Database 11g DBA Handbook
Data Encryption Techniques
Data encryption can enhance security both inside and outside the database. A user may have a
legitimate need for access to most columns of a table, but if one of the columns is encrypted and
the user does not know the encryption key, the information is not usable.
Pages:
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559