Oracle | DBMS_SCHED_JOB

Oracle DBMS_SCHED_JOB_EXPORT Version 23c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Scheduler Job Export Utilities

AUTHID CURRENT_USER

Dependencies

DBMS_PRIV_CAPTURE	DBMS_SCHED_FILE_WATCHER_EXPORT
DBMS_SCHED_ATTRIBUTE_EXPORT	DBMS_SCHED_MAIN_EXPORT
DBMS_SCHED_CHAIN_EXPORT	DBMS_SCHED_PROGRAM_EXPORT
DBMS_SCHED_CLASS_EXPORT	DBMS_SCHED_SCHEDULE_EXPORT
DBMS_SCHED_CONSTRAINT_EXPORT	DBMS_SCHED_WINDOW_EXPORT
DBMS_SCHED_CREDENTIAL_EXPORT	DBMS_SCHED_WINGRP_EXPORT
DBMS_SCHED_EXPORT_CALLOUTS

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvthesh.plb
{ORACLE_HOME}/rdbms/admin/prvtesch.plb

Subprograms

AUDIT_EXP	CREATE_EXP	GRANT_EXP
AUDIT_SYSPRIVS_EXP	DROP_EXP	GRANT_SYSPRIVS_EXP
CHECK_PRIV

AUDIT_EXP

Undocumented dbms_sched_job_export.audit_exp( objid IN NUMBER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

AUDIT_SYSPRIVS_EXP

Undocumented dbms_sched_job_export.audit_sysprivs_exp( version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

CHECK_PRIV

Undocumented dbms_sched_job_export.check_priv(schema IN VARCHAR2);

exec dbms_sched_job_export.check_priv('C##SCOTT');

      

      PL/SQL procedure successfully completed.

CREATE_EXP

Undocumented dbms_sched_job_export.create_exp( objid IN NUMBER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

DROP_EXP

Undocumented dbms_sched_job_export.drop_exp( objid IN NUMBER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

GRANT_EXP

Undocumented dbms_sched_job_export.grant_exp( objid IN NUMBER, isdba IN BINARY_INTEGER, grantor OUT VARCHAR2, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

GRANT_SYSPRIVS_EXP

Undocumented dbms_sched_job_export.grant_sysprivs_exp( version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD