Oracle UD_TRIGS
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented
AUTHID DEFINER
Dependencies
ALL_NESTED_TABLES LTDDL OWM_DYNSQL_ACCESS
ALL_TRIGGERS LTDTRG OWM_MIG_PKG
ALL_USERS LTRIC PLITBLM
DBA_CONSTRAINTS LTUTIL WM$DBA_TAB_COLS
DBA_CONS_COLUMNS LT_EXPORT_PKG WM$RIC_TRIGGERS_TABLE
DBA_DEPENDENCIES OBJ$ WM$UDTRIG_DISPATCHER_SEQUENCE
DBA_TAB_COLS OWM_ASSERT_PKG WM$UDTRIG_DISPATCH_PROCS
LTDBMS_LOB OWM_DDL_PKG WM$UDTRIG_INFO
LTADM OWM_DML_PKG WM_ERROR
Documented No
First Available Not known
Security Model Owned by WMSYS with no privileges granted

The package is protected from use by an Accessible By clause as demonstrated below.
Source {ORACLE_HOME}/rdbms/admin/owmutrgs.plb
{ORACLE_HOME}/rdbms/admin/owmutrgb.plb
Subprograms
 
DROP_ALL_UDTRIG_DISPATCH_PROCS
Undocumented ud_trigs.drop_all_udtrig_dispatch_procs(
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2);
TBD
 
EXISTSTRIGGER
Undocumented ud_trigs.existsTrigger(
trigger_owner_var IN VARCHAR2,
trigger_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
GENUDTRIGDISPATCHER
Undocumented ud_trigs.genUDTrigDispatcher(
table_owner_v   IN VARCHAR2,
table_name_v    IN VARCHAR2,
formal_str      IN VARCHAR2,
bind_formal_str IN VARCHAR2,
bind_actual_str IN VARCHAR2,
io_flag         IN BOOLEAN,
buffercode      IN BOOLEAN,
generateundo    IN BOOLEAN);
TBD
 
GETDISPATCHERINFO
Undocumented ud_trigs.getDispatcherInfo(
tab_owner      IN  VARCHAR2,
tab_name       IN  VARCHAR2,
dispatchername OUT VARCHAR2,
actual_str     OUT VARCHAR2,
actual_str_io  OUT VARCHAR2,
set_clause     OUT VARCHAR2,
insertstr_io   OUT VARCHAR2,
var_decls      OUT VARCHAR2,
bir            OUT BOOLEAN,
air            OUT BOOLEAN,
bur            OUT BOOLEAN,
1aur           OUT BOOLEAN,
1bdr           OUT BOOLEAN,
1adr           OUT BOOLEAN);
TBD
 
GETPARAMSTRS
Undocumented ud_trigs.getParamStrs(
tab_owner          IN  VARCHAR2,
tab_name           IN  VARCHAR2,
actual_str         OUT VARCHAR2,
formal_str         OUT VARCHAR2,
bind_formal_str    OUT VARCHAR2,
bind_actual_str    OUT VARCHAR2,
actual_str_io      OUT VARCHAR2,
formal_str_io      OUT VARCHAR2,
bind_actual_str_io OUT VARCHAR2,
set_clause         OUT VARCHAR2,
insertstr_io       OUT VARCHAR2,
1var_decls         OUT VARCHAR2,
1var_decls_proc    OUT VARCHAR2,
1column_comp_str   OUT VARCHAR2);
TBD
 
HASOWNERNAMEPREFIX
Undocumented ud_trigs.hasOwnerNamePrefix(
str        IN VARCHAR2,
owner_name IN VARCHAR2)
RETURN BOOLEAN;
conn wmsys
Password:

BEGIN
  IF ud_trigs.hasOwnerNamePrefix('C##UWCLASS.SERVERS', 'C##UWCLASS') THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
 IF ud_trigs.hasOwnerNamePrefix('C##UWCLASS.SERVERS', 'C##UWCLASS') THEN
    *
ERROR at line 2:
ORA-06550: line 2, column 6:
PLS-00904: insufficient privilege to access object UD_TRIGS
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
 
INSERTTABLEOWNERNAME
Undocumented ud_trigs.insertTableOwnerName(
table_owner IN VARCHAR2,
table_name  IN VARCHAR2,
description IN VARCHAR2)
RETURN VARCHAR2,;
conn wmsys
Password:

SELECT wmsys.ud_trigs.insertTableOwnerName('C##UWCLASS', 'SERVERS', 'Test')
FROM dual;
SELECT wmsys.ud_trigs.insertTableOwnerName('C##UWCLASS', 'SERVERS', 'Test')
       *
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object UD_TRIGS
 
RECREATETRIGPROCSDG
Undocumented ud_trigs.recreateTrigProcsDG(
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2,
to_version    IN VARCHAR2);
TBD
 
REGENUDTRIGDISPATCHER
Undocumented ud_trigs.regenUDTrigDispatcher(
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2,
buffercode    IN BOOLEAN);
TBD
 
REGENUDTRIGPROCS
Undocumented ud_trigs.regenUDTrigPros(
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2,
buffercode    IN BOOLEAN);
TBD
 
REMOVEDOUBLEQUOTESINUSERNAME
Undocumented ud_trigs.removeDoubleQuotesInUserName(
description_var  IN VARCHAR2,
trig_owner_name  IN VARCHAR2,
table_owner_name IN VARCHAR2,
table_name       IN VARCHAR2)
RETURN VARCHAR2,;
conn wmsys
Password:

SELECT wmsys.ud_trigs.removeDoubleQuotesInUserName('"X"', '"C##UWCLASS"', '"C##UWCLASS"', '"TESTTAB"')
FROM dual;
SELECT wmsys.ud_trigs.removeDoubleQuotesInUserName('"X"', '"C##UWCLASS"', '"C##UWCLASS"', '"TESTTAB"')
       *
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object UD_TRIGS
 
REPLACEOLDNEW
Undocumented ud_trigs.replaceOldNew(
str     IN VARCHAR2,
old_str IN VARCHAR2,
new_str IN VARCHAR2,
newchar IN VARCHAR2)
RETURN VARCHAR2,;
conn wmsys
Password:

SELECT wmsys.ud_trigs.replaceOldNew('AA', 'This is a test', 'This was a test', 'X')
FROM dual;
SELECT wmsys.ud_trigs.replaceOldNew('AA', 'This is a test', 'This was a test', 'X')
       *
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object UD_TRIGS
 
SETGLOBALTRIGGERSETTING
Undocumented ud_trigs.setGlobalTriggerSetting(value_var IN VARCHAR2);
TBD
 
SETTRIGGEREVENTS
Undocumented ud_trigs.setTriggerEvents(
trigger_owner_var IN VARCHAR2,
trigger_name_var  IN VARCHAR2,
triggereventstab  IN TABLE wmsys.ltutil.wm$ident_tab);
TBD
 
SUBSTITUTETABLENAME
Undocumented ud_trigs.substituteTableName(
table_owner    IN VARCHAR2,
table_name     IN VARCHAR2,
new_table_name IN VARCHAR2,
description    IN VARCHAR2)
RETURN VARCHAR2,;
TBD
 
TRF_UDTRGS_ON_COMMIT_DDL
Undocumented ud_trigs.trf_udtrgs_on_commit_ddl(
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2);
TBD
 
TRF_UDTRGS_ON_VER_DISABLE
Undocumented ud_trigs.trf_udtrgs_on_ver_disable(
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2);
TBD
 
TRF_UDTRGS_ON_VER_ENABLE
Undocumented ud_trigs.trf_udtrgs_on_ver_enable(
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2,
procname      OUT VARCHAR2,
actual_str    OUT VARCHAR2,
actual_str_io OUT VARCHAR2,
set_clause    OUT VARCHAR2,
insertstr_io  OUT VARCHAR2,
var_decls     OUT VARCHAR2,
bir           OUT BOOLEAN,
air           OUT BOOLEAN,
bur           OUT BOOLEAN,
aur           OUT BOOLEAN,
bdr           OUT BOOLEAN,
adr           OUT BOOLEAN);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
OWM_ASSERT_PKG
OWM_DDL_PKG
OWM_DML_PKG
OWM_DYNSQL_ACCESS
OWM_MIG_PKG
What's New In 19c
What's New In 20c-21c

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