Oracle LTDDL
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 Workspace Management DDL Utilities
AUTHID DEFINER
Dependencies
LT OWM_CPKG_PKG WM$RIC_TABLE
LTADM OWM_DDL_PKG WM$VERSIONED_TABLES
LTRIC OWM_DYNSQL_ACCESS WM_DDL_UTIL
LTUTIL PLITBLM WM_ERROR
LT_CTX_PKG UD_TRIGS WM_PERIOD
OWM_ASSERT_PKG    
Documented No
First Available Not Known
Security Model Owned by WMSYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/owmddls.plb
Subprograms
 
DISABLEVERSIONING
Undocumented ltddl.disableversioning(
table_owners      IN wmsys.ltutil.wm$ident_tab,
table_names       IN wmsys.ltutil.wm$ident_tab,
force_v           IN BOOLEAN,
ignore_last_error IN BOOLEAN,
keepwmvalid       IN BOOLEAN
undo_space        IN VARCHAR2);
TBD
 
ENABLEVERSIONING
Undocumented ltddl.enableversioning(
table_owners IN wmsys.ltutil.wm$ident_tab,
table_names  IN wmsys.ltutil.wm$ident_tab,
hist         IN VARCHAR2,
validtime    IN BOOLEAN,
vtrange      IN wmsys.wm_period,
undo_space   IN VARCHAR2);
TBD
 
GETVARIABLE_B
Undocumented

This function, possibly the entire package, is protected by an ACCESSIBLE BY clause
ltddl.getvariable_b(varname IN VARCHAR2) RETURN BOOLEAN;
BEGIN
  IF wmsys.ltddl.getvariable_b THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
 IF wmsys.ltddl.getvariable_b THEN
*
ERROR at line 2:
ORA-06550: line 2, column 6:
PLS-00904: insufficient privilege to access object LTDDL
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
 
GETVARIABLE_I
Undocumented ltddl.getvariable_i(varname IN VARCHAR2) RETURN wmsys.ltutil.wm$ident_tab;
TBD
 
UNDOENABLEVER
Undocumented ltddl.undoenablever(
schema   IN VARCHAR2,
tab_name IN VARCHAR2,
sql_stmt IN VARCHAR2,
sql_err  IN VARCHAR2,
execundo IN BOOLEAN);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_WM
LT
LTAQ
LTDTRG
LTI
LTPRIV
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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx