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
CURRENT_USER
Dependencies
DBMS_ASSERT
DBMS_SYS_SQL
KUPCC
DBMS_DATAPUMP
DBMS_UTILITY
KUPCLIB
DBMS_ERRLOG
KU$_DDL
KUPD$DATA_INT
DBMS_LOB
KU$_DDLS
KUPF$FILE
DBMS_LOGREP_UTIL
KU$_DROPCOLLIST
KUPP$PROC
DBMS_METADATA
KU$_MULTI_DDL
KUPUTIL
DBMS_METADATA_DIFF
KU$_MULTI_DDLS
KUPV$FT
DBMS_METADATA_UTIL
KU$_PARSED_ITEM
KUPV$FT_INT
DBMS_SESSION
KU$_PARSED_ITEMS
KUPW$WORKER
DBMS_SQL
KU$_VCNT
PLITBLM
DBMS_SYS_ERROR
Documented
No
First Available
Not known
Security Model
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Creates a DML error logging table that is exactly the same in every respect to the one created by the DBMS_ERRLOG package with the sole exception being the name of the resulting error table.
kupd$data.et_create_error_table(
dml_tbl_owner IN VARCHAR2,
dml_tbl_name IN VARCHAR2,
err_tbl_owner IN VARCHAR2,
err_tbl_name IN VARCHAR2);
kupd$data.fetch_insert_stmt(
schema_name IN VARCHAR2,
table_name IN VARCHAR2,
part_name IN VARCHAR2,
stream_md IN CLOB,
flags IN BINARY_INTEGER,
insert_stmt IN OUT CLOB,
dropped_cols IN OUT sys.ku$_dropcollist,
unpacked_cols IN OUT sys.ku$_dropcollist,
sqlvalid OUT BINARY_INTEGER);
kupd$data.open(
operation IN VARCHAR2,
schema_name IN VARCHAR2,
original_schema IN VARCHAR2,
table_name IN VARCHAR2,
original_table IN VARCHAR2,
part_name IN VARCHAR2,
subpart_name IN VARCHAR2,
metadata IN CLOB)
RETURN NUMBER;
kupd$data.set_debug(debug_flags IN BINARY_INTEGER);
exec kupd$data.set_debug(1);
BEGIN kupd$data.set_debug(1); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object SET_DEBUG
kupd$data.start_job(
ctx_h IN NUMBER,
rowcount OUT NUMBER,
errcount OUT NUMBER,
charsetid OUT NUMBER,
ncharsetid OUT NUMBER,
acc_method OUT NUMBER);
DECLARE
rcOut NUMBER;
ecOut NUMBER;
csOut NUMBER;
ncsOut NUMBER;
amOut NUMBER;
BEGIN
kupd$data.start_job(99, rcOut, ecOut, csOut, ncsOUT, amOut);
dbms_output.put_line(rcOut);
dbms_output.put_line(ecOut);
dbms_output.put_line(csOut);
dbms_output.put_line(ncsOut);
dbms_output.put_line(amOut);
END;
/
DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at "SYS.KUPD$DATA", line 4591
ORA-06512: at "SYS.KUPD$DATA", line 7262
ORA-39096: invalid input value 1 for parameter HANDLE
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPD$DATA", line 1439
ORA-06512: at "SYS.KUPD$DATA", line 6984
ORA-06512: at line 8