General Information
Library Note
Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx .
Purpose
Procedures for Database Vault related actions in the Oracle OCI Cloud
AUTHID
CURRENT_USER
Dependencies
ALL_USERS
DBMS_CLOUD
DBMS_STANDARD
CONFIGURE_DV
DBMS_CLOUD_ADMIN_INTERNAL
DBMS_UTILITY
DBA_ROLES
DBMS_CLOUD_CORE
SESSION_ROLES
DBMS_ASSERT
DBMS_PDB
USER_ROLE_PRIVS
Documented
No
First Available
21c
Security Model
Owned by SYS with no privileges granted
Undocumented
{ORACLE_HOME}/rdbms/admin/dbms_cloud_macadm.sql
{ORACLE_HOME}/rdbms/admin/prvt_cloud_macadm_body.plb
SQL> @?/rdbms/admin/dbms_cloud_macadm.sql
Session altered.
Package created.
Synonym created.
Session altered.
SQL> @?/rdbms/admin/prvt_cloud_macadm_body.plb
Session altered.
SP2-0810: Package Body created with compilation warnings
Errors for PACKAGE BODY DBMS_CLOUD_MACADM:
LINE/COL ERROR
------------------------------------------------------------------------
218/45 PLW-07203: parameter 'CANON_UNAME' may benefit from use of the NOCOPY compiler hint
Session altered.
Subprograms
CONFIGURE_DATABASE_VAULT (new 21c)
Configure Database Vault for a PDB
dbms_cloud_macadm.configure_database_vault(
dvowner_uname IN VARCHAR2,
dvacctmgr_uname IN VARCHAR2 DEFAULT NULL);
BEGIN
dbms_cloud_macadm.configure_database_vault (PDBDEVDVOWNER', 'PDBDEVDVAM');
END;
/
PL/SQL procedure successfully completed.
DISABLE_DATABASE_VAULT (new 21c)
Disable Database Vault for the PDB
dbms_cloud_macadm.disable_database_vault;
exec dbms_cloud_macadm.disable_database_vault ;
PL/SQL procedure successfully completed.
DISABLE_USERMGMT_DATABASE_VAULT (new 21c)
Disble User Management in a DV enabled PDB
dbms_cloud_macadm.disable_usermgmt_database_vault(comp_name IN VARCHAR2);
exec dbms_cloud_macadm.disable_usermgmt_database_vault ('APEX');
PL/SQL procedure successfully completed.
ENABLE_DATABASE_VAULT (new 21c)
Enable Database Vault for the PDB
dbms_cloud_macadm.enable_database_vault;
exec dbms_cloud_macadm.enable_database_vault ;
PL/SQL procedure successfully completed.
ENABLE_USERMGMT_DATABASE_VAULT (new 21c)
Enable User Management in a DV enabled PDB
dbms_cloud_macadm.enable_usermgmt_database_vault(comp_name IN VARCHAR2);
exec dbms_cloud_macadm.enable_usermgmt_database_vault ('APEX');
PL/SQL procedure successfully completed.