Labels

DB (11) Query (11) R12 (8) FWM (7) scripts (7) APPS (6) AD Tools (5) Patch (4) Concurrent request (3) DB Vault (3) Performance Tuning (3) RMAN (3) tips (3) LOG (2) clone (2) ASM (1) RAC (1) error (1) metalink (1) standby (1)
Showing posts with label DB Vault. Show all posts
Showing posts with label DB Vault. Show all posts

Thursday, 14 November 2013

Create Realm-Secured objects to protect schema objects

Create Realm-Secured objects to protect schema objects

Purpose:
  Protect HR schema object from system privileged users

Step 1:
Login as sys or system

Step 2:
Query HR.EMPLOYEES table
(Query: select count(*) from hr.employees;
 Output: count of rows)

Step 3:
Creating Realm-Secured Objects for hr.employees table
Query HR.EMPLOYEES table
(Query: select count(*) from hr.employees;
 Output: Error "ORA-01031: insufficient privileges")

Step 4:
Disable Realm and query HR.EMPLOYEES table
(Query: select count(*) from hr.employees;
 Output: count of rows)

Step 5:
Screenshot explains the above scenario

Wednesday, 13 November 2013

Realms

Realms

A realm is a functional grouping of database schemas and roles that must be secured for a given application

Creating a Realm
Login into Oracle Database Vault Administrator as DV_OWNER or DV_ADMIN
    https://myserver:1158/dva
Navigation:
    Administration->Realms->Create
Enter below
    Name: HR_APPS
    Description: Create Realms for HR tables
    Status: Enabled
    Audit Options: Audit on Failure
Click "OK"

Creating Realm-Secured Objects
Login into Oracle Database Vault Administrator as DV_OWNER or DV_ADMIN
    https://myserver:1158/dva
Navigation:
    Administration->Realms-><select Realm>->Edit->Realm Secured Objects->create
Enter below
    Object Owner:HR
    Object Type:TABLE
    Object Name:EMPLOYEES
Click "OK" and return to Realms and click "OK"

Tuesday, 12 November 2013

Database Vault Uninstall and Reinstall

Database Vault Uninstall

Step 1:
 Stop all service of database
 - Database
 - ASM if available
 - Listener
    lsnrctl stop
 - Cluster
 - Dbconsole
    emctl stop dbconsloe

Step 2:
 Disable Database Vault
    cd $ORACLE_HOME/rdbms/lib
    make -f ins_rdbms.mk dv_off ioracle


Step 3:
 Verify Database Vault Status
 - Start Database and services
 - Query Database
   (SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';
    Output: FALSE)

Step 4:
 Disable Database Vault tiggers
 - Connect as sys
    alter trigger dvsys.dv_before_ddl_trg disable;
    alter trigger dvsys.dv_after_ddl_trg disable;

   
Step 5:
 Identify DV_OWNER and DV_ACCTMGR users
 - Query Database
   (select unique GRANTEE from dba_role_privs where GRANTED_ROLE in ('DV_ACCTMGR','DV_OWNER') and grantee <> 'DVSYS';)

Step 6:
 Remove database vault using dvremov.sql
 - Execute update statement
   (update dvsys.config$ set status=0;
    commit;
)
 - Set recyclebin to OFF
   (alter system set recyclebin=off scope=spfile;
    shutdown immediate;
    startup;
)
 - Execute dvremov.sql and remove DV_OWNER and DV_ACCTMGR users
    (@?/rdbms/admin/dvremov.sql;
    drop user &DV_OWNER cascade;
    drop user &DV_ACCTMGR cascade;
)
 - Set recyclebin to ON
    (alter system set recyclebin=on scope=spfile;
    shutdown immediate;
    startup;
)

Database Vault Reinstall

Step 1:  Stop all service of database
 - Database
 - ASM if available
 - Listener
    lsnrctl stop
 - Cluster
 - Dbconsole
    emctl stop dbconsloe

Step 2:
 Enable Database Vault
    cd $ORACLE_HOME/rdbms/lib
    make -f ins_rdbms.mk dv_on ioracle


Step 3:
 Verify Database Vault Status
 - Start Database and services
 - Query Database
   (SELECT * FROM V$OPTION WHERE PARAMETER = 'Oracle Database Vault';
    Output: TRUE)
Step 4:
  Follow the below screenshots



SCREENSHOT
Description