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 (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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_GSM_CURUSER
DBMS_GSM_DBADMIN
DBMS_GSM_POOLADMIN
DBMS_GSM_UTILITY
What's New In 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx