Oracle Database Vault Business Use Case Two

Protect the database and applications

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:

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;

Oracle Database Vault Customers Absa Group Ltd. (Success Story | Press Release) National Marrow Donor Program (OpenWorld 2011 Daily Newspaper) ROSS Stores (Listen) Hands-On Protect Application Data from DBA and Privileged Users (Viewlet | Oracle by Example) Restrict DBA commands based on IP address (Viewlet | Oracle by Example) Security Features Data Encryption Virtual Private Database Database Auditing Backup Encryption Export file encryption Proxy Authentication Enterprise User Security Secure Application Roles Fine Grained Auditing Related Technologies Database Firewall Audit Vault Data Masking (pdf) Secure Backup Oracle Database Lifecycle Management Identity Management

Technical Information Datasheet Overview Whitepaper Oracle Database Vault Best Practices DBA Administrative Best Practices with Oracle Database Vault Database Vault certified with SAP: (Overview Whitepaper | Datasheet) Database Vault certified with E-Business Suite Database Vault certified with Peoplesoft (Datasheet | Red Paper | Security policies) Database Vault certified with Siebel (Security policies) Database Vault certified with JD Edwards EnterpriseOne (Security policies) Database Vault certified with Oracle Financial Services (iFlex) Database Vault certified with Infosys Finacle Flash Demo Business Whitepaper Oracle Database Vault FAQ Security Options Oracle Database Vault Oracle Advanced Security Oracle Label Security Discussion Forums Security Audit Vault