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 (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.

Related Topics
Built-in Functions
Built-in Packages
Database Security
Database Vault
DBMS_CLOUD
DBMS_CLOUD_ADMIN_INTERNAL
DBMS_CLOUD_CAPABILITY
DBMS_CLOUD_CORE
DBMS_CLOUD_INTERNAL
DBMS_CLOUD_REQUEST
DBMS_CLOUD_TASK
DBMS_CLOUD_TYPES
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx