Oracle | DBMS_CLOUD

Oracle DBMS_CLOUD_MACADM Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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.