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
DataPump internal utilities
AUTHID
DEFINER
Dependencies
DBMS_AQADM
DBMS_UTILITY
KUPP$PROC
DBMS_ASSERT
GV$DATAPUMP_JOB
KUPU$UTILITIES
DBMS_DATAPUMP
KUPC$QUEUE_INT
KUPU$UTILITIES_INT
DBMS_DATAPUMP_INT
KUPC$QUE_INT
KUPUTIL
DBMS_INTERNAL_LOGSTDBY
KUPCC
KUPV$FT
DBMS_LOCK
KUPD$DATA
KUPVLIB
DBMS_RANDOM
KUPF$FILE
KUPW$WORKER
DBMS_SYS_ERROR
KUPM$MCP
Documented
No
First Available
Not known
Security Model
Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.
Some functionality in this package is protected from direct access with an ACCESSIBLE BY clause.
kupv$ft_int.attach_to_job(
job_id IN RAW,
user_name IN VARCHAR2,
job_name IN VARCHAR2,
check_attach IN BOOLEAN,
caller_type IN BINARY_INTEGE)
RETURN NUMBER;
kupv$ft_int.build_mtable_indexes(
mtable_objno IN NUMBER,
opname IN VARCHAR2,
mtable_owner IN VARCHAR2,
mtable_name IN VARCHAR2,
lock_name IN VARCHAR2,
parallel_exp IN BOOLEAN,
fileless IN BOOLEAN,
col_list OUT VARCHAR2);
kupv$ft_int.create_new_job(
user_name IN VARCHAR2,
job_name IN VARCHAR2,
operation IN VARCHAR2,
job_mode IN VARCHAR2,
master_objid IN NUMBER,
has_priv IN NUMBER,
job_id OUT RAW,
control_queue OUT VARCHAR2,
status_queue OUT VARCHAR2);
BEGIN
IF kupv$ft_int.debug_enabled THEN
dbms_output.put_line('In Debug Mode');
ELSE
dbms_output.put_line('Not In Debug Mode');
END IF;
END;
/
IF kupv$ft_int.debug_enabled THEN
*
ERROR at line 2:
ORA-06550: line 2, column 18:
PLS-00904: insufficient privilege to access object DEBUG_ENABLED
ORA-06550: line 2, column 18:
PLS-00382: expression is of wrong type
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
kupv$ft_int.delete_job(
user_name IN VARCHAR2,
job_name IN VARCHAR2,
delete_master IN BOOLEAN,
job_state IN VARCHAR2,
master_porder IN BINARY_INTEGER);
TBD
Overload 2
kupv$ft_int.delete_job(
handle IN NUMBER,
delete_master IN BOOLEAN);
SELECT kupv$ft_int.get_debug_info
FROM dual;
SELECT kupv$ft_int.get_debug_info
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object GET_DEBUG_INFO
kupv$ft_int.get_error_text(
error_number IN BINARY_INTEGER,
parameter1 IN VARCHAR2,
parameter2 IN VARCHAR2,
parameter3 IN VARCHAR2,
parameter4 IN VARCHAR2,
parameter5 IN VARCHAR2,
parameter6 IN VARCHAR2,
parameter7 IN VARCHAR2,
parameter8 IN VARCHAR2,
message_buffer IN OUT VARCHAR2);
Returns job information based on the DataPump job handle provided
Overload 1
kupv$ft_int.get_job_info(
handle IN NUMBER,
user_name OUT VARCHAR2,
job_name OUT VARCHAR2,
operation OUT VARCHAR2,
inst_name OUT VARCHAR2,
job_state OUT VARCHAR2,
job_has_privs OUT BOOLEAN,
master_objid OUT NUMBER,
job_snum OUT NUMBER);
TBD
Returns job information based on the DataPump user and job name provided
Overload 2
kupv$ft_int.get_job_info(
user_name IN VARCHAR2,
job_name IN VARCHAR2,
operation OUT VARCHAR2,
inst_name OUT VARCHAR2,
job_state OUT VARCHAR2,
job_has_privs OUT BOOLEAN,
master_objid OUT NUMBER,
job_snum OUT NUMBER);
Returns job queue information based on the DataPump job handle provided
Overload 1
kupv$ft_int.get_job_queues(
handle IN NUMBER,
que_tabnum OUT BINARY_INTEGER,
control_queue OUT VARCHAR2,
status_queue OUT VARCHAR2);
TBD
Returns job queue information based on the DataPump user and job name provided
Overload 2
kupv$ft_int.get_job_queues(
user_name IN VARCHAR2,
job_name IN VARCHAR2,
caller_type IN BINARY_INTEGER,
que_tabnum OUT BINARY_INTEGER,
control_queue OUT VARCHAR2,
status_queue OUT VARCHAR2);
kupv$ft_int.master_tbl_lock(
user_name IN VARCHAR2,
job_name IN VARCHAR2,
deleting_job IN BOOLEAN,
force_trans IN BOOLEAN,
lock_handle OUT VARCHAR2,
master_objid OUT NUMBER);
BEGIN
IF kupv$ft_int.on_behalf THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/
IF kupv$ft_int.on_behalf THEN
*
ERROR at line 2:
ORA-06550: line 2, column 18:
PLS-00904: insufficient privilege to access object ON_BEHALF
ORA-06550: line 2, column 18:
PLS-00382: expression is of wrong type
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
kupv$ft_int.set_debug(debug_flags IN BINARY_INTEGER);
exec kupv$ft_int.set_debug(1);
BEGIN kupv$ft_int.set_debug(1); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object SET_DEBUG
kupv$ft_int.set_event(
event_number IN NUMBER
level IN NUMBER);
exec kupv$ft_int.set_event(10046, 12);
BEGIN kupv$ft_int.set_event(10046, 12); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object SET_EVENT
kupv$ft_int.valid_handle(handle IN NUMBER) RETURN BOOLEAN;
BEGIN
IF kupv$ft_int.valid_handle(42) THEN
dbms_output.put_line('Handle Is Valid');
ELSE
dbms_output.put_line('Handle Is Not Valid');
END IF;
END;
/ Handle Is Not Valid