Oracle | DBMS_GSM

Oracle DBMS_GSM_GSMUSER 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 Undocumented

AUTHID CURRENT_USER

Dependencies

ALL_USERS	DBMS_GSM_UTILITY	ENC_PWD_LIST_T
DBMS_GSM_COMMON	DBMS_LOB	EXECUTECOMMAND
DBMS_GSM_DBADMIN	DBMS_SQL	PLITBLM
DBMS_GSM_POOLADMIN	DBMS_SYS_ERROR	SHARD_KEYS
DBMS_GSM_SEC	DBMS_SYS_SQL	UTL_RAW

Documented No

First Available 23ai

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);

Security Model Owned by SYS with EXECUTE grnated to GSMADMIN_INTERNAL and the GSMUSER_ROLE role.

Source {ORACLE_HOME}/rdbms/admin/dbmsgwmfix.sql
{ORACLE_HOME}/rdbms/admin/prvtgwmfix.sql

Subprograms

EXECASUSER

EXECASUSERID

EXECASUSER (new 23ai)

Undocumented dbms_gsm_gsmuser.execAsUser(exec_user varchar2, ddlid IN NUMBER, qstring IN BLOB, ignore_error IN BOOLEAN DEFAULT FALSE, cur_key IN NUMBER DEFAULT 0) ACCESSIBLE BY ( PACKAGE ggsys.ggsharding, PROCEDURE gsmadmin_internal.executeDDL, PROCEDURE gsmadmin_internal.executeCommand, PACKAGE gsmadmin_internal.dbms_gsm_pooladmin, PACKAGE gsmadmin_internal.dbms_gsm_dbadmin, PACKAGE gsmadmin_internal.dbms_gsm_utility);

TBD

EXECASUSERID (new 23ai)

Undocumented dbms_gsm_gsmuser.execAsUserID( exec_id IN NUMBER, ddlid IN NUMBER, qstring IN BLOB, ignore_error IN BOOLEAN DEFAULT FALSE, curr_key IN NUMBER DEFAULT 0) ACCESSIBLE BY ( PACKAGE ggsys.ggsharding, PROCEDURE gsmadmin_internal.executeDDL, PROCEDURE gsmadmin_internal.executeCommand, PACKAGE gsmadmin_internal.dbms_gsm_pooladmin, PACKAGE gsmadmin_internal.dbms_gsm_dbadmin, PACKAGE gsmadmin_internal.dbms_gsm_utility);

TBD