Oracle | LTI

Oracle LTI 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 Workspace Management internal utilities

AUTHID CURRENT_USER

Dependencies

ALL_MP_PARENT_WORKSPACES	LTUTIL	SESSION_PRIVS
ALL_TAB_PRIVS_RECD	LT_CTX_PKG	SESSION_ROLES
ALL_WORKSPACE_SAVEPOINTS	OWM_ASSERT_PKG	USER_SYS_PRIVS
DBMS_STANDARD	OWM_BULK_LOAD_PKG	USER_VIEWS
DUAL	OWM_IEXP_PKG	USER_WM_PRIVS
LT	OWM_MP_PKG	USER_WORKSPACES
LTADM	OWM_VSCRIPT_PKG	WM$NV_PAIR_NT_TYPE
LTAQ	PLITBLM	WM$NV_PAIR_TYPE
LTPRIV	ROLE_SYS_PRIVS	WM_ERROR
LTRIC	ROLE_TAB_PRIVS

Documented No

First Available 20c

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/owmltis.plb

Subprograms

ADDASPARENTWORKSPACE	GRANTSYSTEMPRIV	REVOKEGRAPHPRIV
CHANGEWORKSPACETYPE	GRANTWORKSPACEPRIV	REVOKESYSTEMPRIV
CHECKTABLEPRIVS	HASWMADMIN	REVOKEWORKSPACEPRIV
CHECKWHERECLAUSE	IMPORT	ROLLBACKTABLE
COMPRESSWORKSPACE	MERGETABLE	ROLLBACKTOSP
COMPRESSWORKSPACETREE	MERGEWORKSPACE	ROLLBACKWORKSPACE
CREATESAVEPOINT	REFRESHTABLE	ROLLBACKWORKSPACE_INTERNAL
CREATEWORKSPACE	REFRESHWORKSPACE	SETACTIVETSFORDML
DELETESAVEPOINT	REMOVEASPARENTWORKSPACE	SETCONFLICTWORKSPACE_INTERNAL
EXPORT	REMOVEDEFERREDWORKSPACES	SETWORKSPACELOCKMODEOFF
GOTOWORKSPACE_INTERNAL	REMOVEWORKSPACE	SETWORKSPACELOCKMODEON
GRANTGRAPHPRIV	REMOVEWORKSPACETREE

ADDASPARENTWORKSPACE (new 20c)

Undocumented lti.addAsParentWorkspace( workspace IN VARCHAR2, parent_workspace IN VARCHAR2)

Protected by an ACCESSIBLE BY clause

CHANGEWORKSPACETYPE (new 20c)

Undocumented lti.changeWorkspaceType( workspace IN VARCHAR2, workspace_type IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

CHECKTABLEPRIVS (new 20c)

Undocumented lti.checkTablePrivs( towner IN VARCHAR2, tabname IN VARCHAR2) RETURN BOOLEAN;

Protected by an ACCESSIBLE BY clause

CHECKWHERECLAUSE (new 20c)

Undocumented lti.checkWhereClause( owner_var IN VARCHAR2, table_name_var IN VARCHAR2, where_clause IN OUT VARCHAR2, st_owner_v IN VARCHAR2, st_name_v IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

COMPRESSWORKSPACE (new 20c)

Undocumented lti.compressWorkspace( workspace IN VARCHAR2, compress_view_wo_overwrite IN BOOLEAN, firstsp IN VARCHAR2, secondsp IN VARCHAR2, auto_commit IN BOOLEAN, commit_in_batches IN BOOLEAN, batch_size IN VARCHAR2, remove_latest_deleted_rows IN BOOLEAN);

Protected by an ACCESSIBLE BY clause

COMPRESSWORKSPACETREE (new 20c)

Undocumented lti.compressWorkspaceTree( workspace IN VARCHAR2, compress_view_wo_overwrite IN BOOLEAN, auto_commit IN BOOLEAN, commit_in_batches IN BOOLEAN, batch_size IN VARCHAR2, remove_latest_deleted_rows IN BOOLEAN);

Protected by an ACCESSIBLE BY clause

CREATESAVEPOINT (new 20c)

Undocumented lti.createSavepoint( workspace IN VARCHAR2, savepoint_name IN VARCHAR2, description IN VARCHAR2)

Protected by an ACCESSIBLE BY clause

CREATEWORKSPACE (new 20c)

Undocumented lti.createWorkspace( workspace IN VARCHAR2, isrefreshed IN BOOLEAN, description IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

DELETESAVEPOINT (new 20c)

Undocumented lti.deleteSavepoint( workspace IN VARCHAR2, savepoint_name IN VARCHAR2, compress_view_wo_overwrite IN BOOLEAN, auto_commit IN BOOLEAN, commit_in_batches IN BOOLEAN, batch_size IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

EXPORT (new 20c)

Undocumented lti.export( table_name IN VARCHAR2, staging_table IN VARCHAR2, workspace IN VARCHAR2, where_clause IN VARCHAR2, export_scope IN VARCHAR2, after_savepoint_name IN VARCHAR2, as_of_savepoint_name IN VARCHAR2, after_instant IN DATE, as_of_instant IN DATE, versioned_db IN BOOLEAN, overwrite_existing_data IN BOOLEAN, auto_commit IN BOOLEAN);

Protected by an ACCESSIBLE BY clause

GOTOWORKSPACE_INTERNAL (new 20c)

Undocumented lti.gotoWorkspace_internal(state IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

GRANTGRAPHPRIV (new 20c)

Undocumented lti.grantGraphPriv( priv_types IN VARCHAR2, leaf_workspace IN VARCHAR2, grantee IN VARCHAR2, node_types IN VARCHAR2, grant_option IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

GRANTSYSTEMPRIV (new 20c)

Undocumented lti.grantSystemPriv( priv_types IN VARCHAR2, grantee IN VARCHAR2, grant_option IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

GRANTWORKSPACEPRIV (new 20c)

Undocumented lti.grantWorkspacePriv( priv_types IN VARCHAR2, workspace IN VARCHAR2, grantee IN VARCHAR2, grant_option IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

HASWMADMIN (new 20c)

Undocumented lti.hasWMAdmin RETURN BOOLEAN;

BEGIN

        IF wmsys.lti.hasWMAdmin THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

       IF wmsys.lti.hasWMAdmin THEN

      *

      ERROR at line 2:

      ORA-06550: line 2, column 6:

      PLS-00904: insufficient privilege to access object LTI

      ORA-06550: line 2, column 3:

      PL/SQL: Statement ignored

IMPORT (new 20c)

Undocumented lti.import( staging_table IN VARCHAR2, to_table IN VARCHAR2, to_workspace IN VARCHAR2, from_workspace IN VARCHAR2, where_clause IN VARCHAR2, import_scope IN VARCHAR2, ancestor_savepoint_workspace IN VARCHAR2, ancestor_savepoint_name IN VARCHAR2, apply_locks IN BOOLEAN, enforceucflag IN BOOLEAN, enforcericflag IN BOOLEAN);

Protected by an ACCESSIBLE BY clause

MERGETABLE (new 20c)

Undocumented lti.mergeTable( workspace IN VARCHAR2, table_id IN VARCHAR2, where_clause IN VARCHAR2, create_savepoint IN BOOLEAN, remove_data IN BOOLEAN, auto_commit IN BOOLEAN);

Protected by an ACCESSIBLE BY clause

MERGEWORKSPACE (new 20c)

Undocumented lti.mergeWorkspace( workspace IN VARCHAR2, create_savepoint IN BOOLEAN, remove_workspace IN BOOLEAN, auto_commit IN BOOLEAN);

Protected by an ACCESSIBLE BY clause

REFRESHTABLE (new 20c)

Undocumented lti.refreshTable( workspace IN VARCHAR2, table_id IN VARCHAR2, where_clause IN VARCHAR2, auto_commit IN BOOLEAN);

Protected by an ACCESSIBLE BY clause

REFRESHWORKSPACE (new 20c)

Refresh the workspace lti.refreshWorkspace( workspace IN VARCHAR2, auto_commit IN BOOLEAN, copy_data IN BOOLEAN);

Protected by an ACCESSIBLE BY clause

REMOVEASPARENTWORKSPACE (new 20c)

Remove the parent workspace lti.removeAsParentWorkspace( mp_leaf_workspace IN VARCHAR2, parent_workspace IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

REMOVEDEFERREDWORKSPACES (new 20c)

Undocumented lti.removeDeferredWorkspaces;

Protected by an ACCESSIBLE BY clause

REMOVEWORKSPACE (new 20c)

Undocumented lti.removeWorkspace( workspace IN VARCHAR2, defer_option IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

REMOVEWORKSPACETREE (new 20c)

Undocumented lti.removeWorkspaceTree( workspace IN VARCHAR2, defer_option IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

REVOKEGRAPHPRIV (new 20c)

Undocumented lti.revokeGraphPriv( priv_types IN VARCHAR2, leaf_workspace IN VARCHAR2, grantee IN VARCHAR2, node_types IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

REVOKESYSTEMPRIV (new 20c)

Undocumented lti.revokeSysemPriv( priv_types IN VARCHAR2, grantee IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

REVOKEWORKSPACEPRIV (new 20c)

Undocumented lti.revokeWorkspacePriv( priv_types IN VARCHAR2, workspace IN VARCHAR2, grantee IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

ROLLBACKTABLE (new 20c)

Undocumented lti.rollbackTable( workspace IN VARCHAR2, table_id IN VARCHAR2, sp_name IN VARCHAR2, where_clause IN VARCHAR2, remove_locks IN BOOLEAN, auto_commit IN BOOLEAN);

Protected by an ACCESSIBLE BY clause

ROLLBACKTOSP (new 20c)

Undocumented lti.rollbackToSP( workspace IN VARCHAR2, savepoint_name IN VARCHAR2)

Protected by an ACCESSIBLE BY clause

ROLLBACKWORKSPACE (new 20c)

Undocumented lti.rollbackWorkspace(workspace IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

ROLLBACKWORKSPACE_INTERNAL (new 20c)

Undocumented lti.rolbackWorkspace_Internal( in_state IN VARCHAR2, table_name IN VARCHAR2, cpver IN NUMBER, postver IN NUMBER, operation IN VARCHAR2, defer_option IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

SETACTIVETSFORDML (new 20c)

Undocumented lti.setActiveTSForDML;

exec wmsys.lti.setActiveTSForDML;

      BEGIN wmsys.lti.setActiveTSForDML; END;

      *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object LTI

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

SETCONFLICTWORKSPACE_INTERNAL (new 20c)

Undocumented lti.setConflictWorkspace_Internal(state IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

SETWORKSPACELOCKMODEOFF (new 20c)

Disables Workspace Locking lti.setWorkspaceLockModeOff(workspace IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

SETWORKSPACELOCKMODEON (new 20c)

Enables Workspace Locking lti.setWorkspaceLockModeOn( workspace IN VARCHAR2, lockmode IN VARCHAR2, override IN BOOLEAN);

Protected by an ACCESSIBLE BY clause

Related Topics

Built-in Functions

Built-in Packages

Database Security

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