Oracle DBMS_GSM_CURUSER
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
CREATEDUPLICATEDTABLE REFRESHGROUP EXEC_SHARD_PLSQL
DBMS_GSM_NOPRIV MODIFYDUPLICATEDTABLEREFRESHGROUP
DBMS_GSM_SEC REFRESHDUPLICATEDTABLE
DBMS_GSM_VPD REMOVEDUPLICATEDTABLEREFRESHGROUP
DBMS_GSM_XDB RESUMEDUPLICATEDTABLEREFRESH
DBMS_SESSION STOPDUPLICATEDTABLEREFRESH
Documented No
First Available 23.1 Beta
Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, READ_ONLY);
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/dbmsgwmfix.sql
{ORACLE_HOME}/rdbms/admin/prvtgwmfix.plb
Subprograms
 
SETCURUSER (new 23c)
Set the current user dbms_gsm_curuser.setCurUser(user IN VARCHAR2 DEFAULT NULL);
PRAGMA SUPPLEMENTAL_LOG_DATA(setCurUser, READ_ONLY);
exec dbms_gsm_curuser.setCurUser;

PL/SQL procedure successfully completed.
 
UNSETCURUSER (new 23c)
Unset the current user dbms_gsm_curuser.unsetCurUser;
PRAGMA SUPPLEMENTAL_LOG_DATA(unsetCuruser, READ_ONLY);
exec dbms_gsm_curuser.unsetCurUser;

PL/SQL procedure successfully completed.

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_GSM_GSMUSER
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