Oracle DBMS_GSM

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

DECDDLVCH

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