Oracle DBMS_GSM_DDL
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 Undocumented Global Service Manager Administration Utilities.

The installation file contains the following note: "since changes to gsmadmin_internal tables aren't propagated to logical standbys, mark all gsm packages as unsupported"
AUTHID DEFINER
Dependencies
DBMS_GSM_COMMON DBMS_LOB SHARD_KEYS
DBMS_GSM_SEC_LIB DDL_REQUESTS_PWD UTL_RAW
Documented No
First Available 20c
Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);
Security Model Owned by SYS with EXECUTE granted to the GSMADMIN_ROLE and GSMCATUSER roles.
Source {ORACLE_HOME}/rdbms/admin/dbmsgwmfix.sql
Subprograms
 
DECDDL (new 20c)
Undocumented dbms_gsm_ddl.decDDL(
key_id IN NUMBER DEFAULT NULL,
ddl_text IN BLOB,
ddlid IN NUMBER DEFAULT NULL)
RETURN CLOB;
TBD
 
DECDDLVCH (new 20c)
Undocumented dbms_gsm_ddl.decDDLVch(
key_id    IN NUMBER DEFAULT NULL,
ddl_text  IN CLOB   DEFAULT NULL,
enc_ddl   IN BLOB   DEFAULT NULL,
ddlid     IN NUMBER DEFAULT NULL,
trim_size IN NUMBER DEFAULT 32767)
RETURN VARCHAR2;
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_GSM_ALERTS
DBMS_GSM_CLOUDADMIN
DBMS_GSM_COMMON
DBMS_GSM_DBADMIN
DBMS_GSM_FIX
DBMS_GSM_FIXED
DBMS_GSM_NOPRIV
DBMS_GSM_POOLADMIN
DBMS_GSM_SEC
DBMS_GSM_UTILITY
DBMS_GSM_XDB
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