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.
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);
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);
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);
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);
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
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);
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);
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);
lti.rolbackWorkspace_Internal(
in_state IN VARCHAR2,
table_name IN VARCHAR2,
cpver IN NUMBER,
postver IN NUMBER,
operation IN VARCHAR2,
defer_option IN VARCHAR2);
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