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

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