| Oracle® Database Vault Administrator's Guide 11g Release 1 (11.1) Part Number B31222-01 |
|
|
View PDF |
| Oracle® Database Vault Administrator's Guide 11g Release 1 (11.1) Part Number B31222-01 |
|
|
View PDF |
This chapter explains how you can monitor Oracle Database Vault. It includes the following sections:
You can check for security violations, such as realm or command rule violations. This feature displays data such as the user name of the person committing the violation, the action they committed, and a time stamp of the activity.
Follow these steps:
Log in to Oracle Database Vault Administrator with an account that uses the DV_OWNER, DV_ADMIN, or DV_SECANALYST role.
"Starting Oracle Database Vault Administrator" explains how to log in.
In the Administration page, click Monitor.
At the top of the Monitor page, set a period of time for the monitoring action by selecting from the Show Records For list and clicking Go.
This section of the Monitor page also indicates the last time the data on the page was refreshed.
In the Monitor page, click Security Violation Attempts.
A table appears, listing security policy changes.
You can view structural changes to the database or database schema objects. This feature also audits statements such as CREATE TABLE, ALTER TABLE, DROP TABLE, and ALTER DATABASE. It audits all commands, not just commands that are used in command rules. For example, if someone has unexpectedly altered a table on a production system, you can use this feature to determine what is happening.
Follow these steps:
Log in to Oracle Database Vault Administrator with an account that uses the DV_OWNER, DV_ADMIN, or DV_SECANALYST role.
"Starting Oracle Database Vault Administrator" explains how to log in.
In the Administration page, click Monitor.
At the top of the Monitor page, set a period of time for the monitoring action by selecting from the Show Records For list and clicking Go.
This section of the Monitor page also indicates the last time the data on the page was refreshed.
In the Monitor page, click Database Configuration and Structural Changes.
A table similar to the following appears:
You can check the number of policy changes for the categories in the following list. These categories reflect changes to the database security policy (that is, its configuration) in any given environment. If something changes that is security related, you can use the chart and tables to drill down to find unexpected changes that should be investigated.
Database Vault policy: Shows changes made through the Oracle Database Vault administrative packages or user interface, indicating Oracle Database Vault configuration or policy changes.
Label Security policy: Shows changes made through the Oracle Database Vault administrative packages or user interface, indicating Oracle Label Security policy or privilege changes.
Audit Policy: Shows changes to the database audit policy coming from AUDIT or NOAUDIT statements. Before you can audit the database audit policy, the AUDIT_TRAIL initialization parameter must be set to DB. See "About the Baseline Oracle Database Vault Auditing Policy" for an example.
Privilege Grants: Shows changes to system or object privilege GRANT statements.
Privilege Revokes: Shows changes to system or object privilege REVOKE statements.
Database Account: Shows changes to CREATE USER, ALTER USER, or DROP USER statements.
Database Role: Shows changes to CREATE ROLE, ALTER ROLE, or DROP ROLE statements.
To monitor security policy changes by category:
Log in to Oracle Database Vault Administrator using the Oracle Database Vault owner (with the DV_OWNER role) or security analyst account (with the DV_SECANALYST role).
"Starting Oracle Database Vault Administrator" explains how to log on.
In the Administration page, click Monitor.
At the top of the Monitor page, set a period of time for the monitoring action by selecting from the Show Records For list and clicking Go.
This section of the Monitor page also indicates the last time the data on the page was refreshed.
In the Monitor page, check the graph under Security Policy Changes by Category.
A graph similar to the following appears, which shows the number of security policy changes based on the following categories: Oracle Database Vault policy, Oracle Label Security policy, audit policy, privilege grants and revokes, database accounts, and database roles.
You can check the details of security policy changes, such the user who made the change, the action that occurred, the time stamp of the change, and so on.
To monitor security policy changes by detail:
Log in to Oracle Database Vault Administrator with an account that uses the DV_OWNER, DV_ADMIN, or DV_SECANALYST role.
"Starting Oracle Database Vault Administrator" explains how to log in.
In the Administration page, click Monitor.
At the top of the Monitor page, set a period of time for the monitoring action by selecting from the Show Records For list and clicking Go.
This section of the page also indicates the last time the data on the page was refreshed.
In the Monitor page, click Security Policy Changes by Detail.
A table appears, listing the details for security policy changes.
