Oracle Database Vault: Business Use Case Two

Point your Browser to the Oracle Database Vault Web Administration Interface (dva) using the following URL:

  http://<hostname>:<port>/dva

and login using the Database Vault owner account. Click on 'Command Rules', you will see a list, including TRUNCATE TABLE, CREATE TABLE, and many more. In this example, create a command rule for the DROP TABLE command:

Recommended command rules: ALTER TABLE CREATE TABLE TRUNCATE TABLE CREATE CLUSTER DROP CLUSTER CREATE DATABASE LINK DROP DATABASE LINK DROP INDEX DROP SEQUENCE DROP TABLESPACE CREATE VIEW DROP VIEW CREATE SYNONYM DROP SYNONYM The same could be achieved using the following script: begin dvsys.dbms_macadmin.CREATE_COMMAND_RULE ( command => 'drop_table', rule_set_name => 'Disabled', object_owner => 'HR', object_name => '%', enabled => 'YES'); commit; end; / commit;