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

Direct access to this package is prevented by means of an Accessible By clause.
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
LTRIC
WM_DDL_UTIL
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