Oracle | DBMS_CLOUD

Oracle DBMS_CLOUD_MACADM Version 21c

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	DISABLE_USERMGMT_DATABASE_VAULT	ENABLE_USERMGMT_DATABASE_VAULT
DISABLE_DATABASE_VAULT	ENABLE_DATABASE_VAULT

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.