Solution : https://service.sap.com/sap/support/notes/1640715 (SAP Service marketplace login required)
Summary :
This SAP Note provides guidelines for testing Oracle Database Vault within an SAP system, outlining various standard test scenarios and suggesting additional tests based on specific system environments and configurations. Not all listed tests are mandatory, but they are particularly useful when implementing Database Vault in an SAP setting for the first time. Key areas include ensuring that the SAP DV Policy secures application data from unauthorized high-privileged database users, verifying that administrative tasks can be performed via SAP BR*Tools, and confirming system connectivity and functionality post-configuration adjustment. Instructions also include SQL*Plus command for user login identification enhancement and practical steps for testing through SQL queries to ensure proper Database Vault operation and restrictions compliance.
Key words :
os> cd $oracle_home/sap/ora_dbvaultos> sqlplus secadminsql> @dv_policy export disablesql> @dv_policy import disable installing / updating sapdba role steps, sysos> cd <oracle_home>/sap/ora_dbvaultos> sqlplus secadminsecadmin sql> @dv_policy patch enablethe effect, sysos> cd <oracle_home>/sap/ora_dbvaultos> sqlplus secadminsecadmin sql> @dv_policy patch disablethe effect, /oracle/qo1/112_64/bin/exp parfile=/oracle/qo1/sapreorg/sehcshiu/parfile, /oracle/qo1/112_64/bin/exp parfile=/oracle/qo1/sapreorg/sehcshwg/parfile, sap enhancement packages ehp / ehpi verifying database vault status find, os> cd <oracle_home>/sap/ora_dbvaultos> sqlplus secadminfor export, svebr0477i oracle pfile /oracle/qo1/112_64/dbs/initqo1, secadmin @ qo1 sql> @dv_policy export status brspace - data export, access/modify sap table datasystem sql> create table sapsr3
Related Notes :
| 1605004 | Database Vault: Online Redefinition |
| 1597194 | Installing Oracle Database Vault in an SAP Environment |
| 1502374 | Database Vault Policy Scripts for SAP (11.2) |
| 1355140 | Using Oracle Database Vault in an SAP environment |