Oracle | DBMS_CLOUD

Oracle DBMS_CLOUD_MACADM Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Procedures for Database Vault related actions in the Oracle OCI Cloud Database as a Service.

AUTHID CURRENT_USER

Dependencies

ALL_USERS	DBMS_CLOUD_ADMIN_INTERNAL	DBMS_UTILITY
CONFIGURE_DV	DBMS_CLOUD_CORE	SESSION_ROLES
DBMS_ASSERT	DBMS_STANDARD	USER_ROLE_PRIVS
DBMS_CLOUD

Documented No

First Available 21c

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/dbms_cloud_macadm.sql
{ORACLE_HOME}/rdbms/admin/prvt_cloud_macadm_body.plb

SQL> @?/rdbms/admin/prvt_cloud_core.plb

      SQL> @?/rdbms/admin/prvt_cloud_core_body.plb

      

      SQL> @?/rdbms/admin/prvt_cloud_admin_int.plb

      SQL> @?/rdbms/admin/prvt_cloud_admin_int_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	ENABLE_DATABASE_VAULT
DISABLE_DATABASE_VAULT	ENABLE_USERMGMT_DATABASE_VAULT
DISABLE_USERMGMT_DATABASE_VAULT

CONFIGURE_DATABASE_VAULT

Configure Database Vault for a PDB dbms_cloud_macadm.configure_database_vault( dvowner_uname IN VARCHAR2, dvacctmgr_uname IN VARCHAR2 DEFAULT NULL);

exec dbms_cloud_macadm.configure_database_vault(PDBDEVDVOWNER', 'PDBDEVDVAM');

      

      PL/SQL procedure successfully completed.

DISABLE_DATABASE_VAULT

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

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

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

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.