Note:
To make the charts used in the Monitor page accessible for to users of assistive technology, see "Enabling Oracle Database Vault Accessibility" in Oracle Database Vault Installation Guide.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.
Before you can view these events, you must ensure that the AUDIT_TRAIL
initialization parameter is set to DB
or DB, EXTENDED
.
To check for security violations:
Log in to Oracle Database Vault Administrator as a user who has been granted the DV_OWNER
, DV_ADMIN
, or DV_SECANALYST
role.
"Starting Oracle Database Vault" 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.
Before you can view these events, you must ensure that the AUDIT_TRAIL
initialization parameter is set to DB
or DB, EXTENDED
.
Follow these steps:
Log in to Oracle Database Vault Administrator as a user who has been granted the DV_OWNER
, DV_ADMIN
, or DV_SECANALYST
role.
"Starting Oracle Database Vault" explains how to log in.
In the Administration page, click Monitor.
At the top of the Monitor page, set a period 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.
Before you can view these events, you must ensure that the AUDIT_TRAIL
initialization parameter is set to DB
or DB, EXTENDED
.
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.
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 as a user who has been granted the DV_OWNER
, DV_ADMIN
, or DV_SECANALYST
role.
"Starting Oracle Database Vault" explains how to log on.
In the Administration page, click Monitor.
At the top of the Monitor page, set a period 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.
Before you can view these events, you must ensure that the AUDIT_TRAIL
initialization parameter is set to DB
or DB, EXTENDED
.
To monitor security policy changes by detail:
Log in to Oracle Database Vault Administrator as a user who has been granted DV_OWNER
, DV_ADMIN
, or DV_SECANALYST
role.
"Starting Oracle Database Vault" explains how to log in.
In the Administration page, click Monitor.
At the top of the Monitor page, set a period 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.