Solution : https://service.sap.com/sap/support/notes/1678937 (SAP Service marketplace login required)
Summary :
This SAP Note discusses the collaboration between database administrators (DBAs) and security administrators in environments using Oracle Database Vault (DV). It outlines the cooperative tasks and additional steps required for common database management activities when DV is enabled. Crucially, it addresses scenarios about the interaction between these administrators and the specifics of managing Oracle databases integrated with SAP. Appropriate for database and security administrators, it also provides guidance on using SAP DV Policy scripts, installing the DV, enabling/disabling DV, and handling SAP DV Policy configurations. The note also mentions proper procedures for database segment management with BRSPACE and details specific command usage for secured data operations.
Key words :
restart enterprise manager database controlos> emctl start dbconsole installing database patches - patching, os> <oracle_home_tgt>/bin/chopt disable dv upgrade taskssee sap database upgrade guide 'upgrade, <table> -ndc data export / data import database vault prevents privileged database users, os> cd $oracle_home/oc4j/j2ee/os> cd <oc4j_dbconsole_service_name>/configos> cp server, temporarily disable grant command rulesecadmin sql> @dv_policy commandrule grant disablesys, stop enterprise manager database controlos> emctl stop dbconsole, syssql> @dv_policy user enable syssql> @dv_policy user disable sysnow, force <task specific brspace options> -ndcperforming database segment management, user support_dbasql> @dv_policy support_access status resetting sap dv policy, htm#bgbcfbdi] backup/export/import database vault security policy
Related Notes :
| 1595640 | Operating System Accounts for Database Vault |
| 1595481 | Database User Management in a Database Vault Environment |
| 1502374 | Database Vault Policy Scripts for SAP (11.2) |
| 1355140 | Using Oracle Database Vault in an SAP environment |