Oracle | DBMS_GSM

Oracle DBMS_GSM_GSMUSER Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented

AUTHID CURRENT_USER

Dependencies

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

Documented No

First Available 23.1 Beta

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 23c)

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 23c)

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