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 but appears to relate to Data Guard Physical Standby DataPump Support
AUTHID
DEFINER
Dependencies
DBMS_DATAPUMP
KU$_JOBDESC
KU$_STATUS
Documented
No
First Available
12.1
Security Model
Owned by SYS with EXECUTE granted to EXECUTE_CATALOG_ROLE role
Demo fails because it was not run from within an executing DataPump job.
Identical name and parameters were found in TSDP$DATAPUMP
pstdy_datapump_support.instance_callout_imp(
obj_name IN VARCHAR2,
obj_schema IN VARCHAR2,
obj_type IN NUMBER,
prepost IN BINARY_INTEGER,
action OUT VARCHAR2,
alt_name OUT VARCHAR2);
CREATE TABLE c##uwclass.test AS
SELECT * FROM tab$;
Table created.
SELECT type#
FROM obj$
WHERE name = 'TEST';
TYPE#
------
2
DECLARE
lAction VARCHAR2(120);
lAltName VARCHAR2(120);
BEGIN
pstdy_datapump_support.instance_callout_imp('TEST', 'C##UWCLASS', 2, 0, lAction, lAltName);
dbms_output.put_line(lAction);
dbms_output.put_line(lAltName);
END;
/
DECLARE
*
ERROR at line 1:
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4747
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4494
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5973
ORA-06512: at "SYS.PSTDY_DATAPUMP_SUPPORT", line 42
ORA-06512: at line 5
Demo code doesn't fail but neither is there an output
pstdy_datapump_support.instance_export_action(
obj_name IN VARCHAR2,
obj_schema IN VARCHAR2,
obj_type IN NUMBER,
tgt_version IN VARCHAR2,
action OUT VARCHAR2,
alt_name OUT VARCHAR2,
where_clause OUT VARCHAR2);