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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.