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 DBMS_SCHEDULER utilities
AUTHID
DEFINER
Dependencies
ADD_AGENT_CERTIFICATE
DBMS_TRANSACTION
SCHEDULER_FILEWATCHER_RES_LIST
AQ$_AGENT
DBMS_UTILITY
SUBMIT_FILEWATCH_RESULTS
DBMS_AQ
DUAL
SUBMIT_JOB_RESULTS
DBMS_ASSERT
FILEWATCH_REQUEST_RESEND
SUBMIT_JOB_RESULTS2
DBMS_CRYPTO
OBJ$
UNREGISTER_AGENT
DBMS_ISCHED
PLITBLM
UTL_ENCODE
DBMS_ISCHED_REMDB_JOB
REGISTER_AGENT3
UTL_FILE
DBMS_LOB
REG_START
UTL_I18N
DBMS_LOCK
SCHEDULER$_DESTINATIONS
UTL_INADDR
DBMS_SCHEDULER
SCHEDULER$_GLOBAL_ATTRIBUTE
UTL_RAW
DBMS_SCHEDULER_LIB
SCHEDULER_FILEWATCHER_REQUEST
UTL_TCP
DBMS_STANDARD
SCHEDULER_FILEWATCHER_REQ_LIST
UTL_URL
DBMS_SYSTEM
SCHEDULER_FILEWATCHER_RESULT
Documented
No
First Available
12.1
Security Model
Owned by SYS with EXECUTE granted to the REMOTE_SCHEDULER_AGENT role.
dbms_isched_remote_access.add_agent_certificate(
hostname IN VARCHAR2,
certificate IN VARCHAR2,
current_date IN VARCHAR2,
password_hash IN VARCHAR2,
port IN VARCHAR2,
nonce IN VARCHAR2,
enc_key IN VARCHAR2,
key_hash IN VARCHAR2,
agent_name IN VARCHAR2,
hashed_password IN VARCHAR2,
db_name OUT VARCHAR2,
my_nonce OUT VARCHAR2,
my_mac OUT VARCHAR2);
exec dbms_isched_remote_access.agent_registration_locked;
*
ERROR at line 1:
ORA-00988: missing or invalid password(s)
ORA-06512: at "SYS.DBMS_ISCHED", line 3742
ORA-06512: at "SYS.DBMS_ISCHED_REMOTE_ACCESS", line 137
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_ISCHED_REMOTE_ACCESS", line 123
ORA-06512: at line 1
BEGIN
IF dbms_isched_remote_access.attempt_limit_reached THEN
dbms_output.put_line('Attempt Limit Reached');
ELSE
dbms_output.put_line('Attempt Limit Not Yet Reached');
END IF;
END;
/
*
ERROR at line 1:
ORA-00988: missing or invalid password(s)
ORA-06512: at "SYS.DBMS_ISCHED", line 3742
ORA-06512: at "SYS.DBMS_ISCHED_REMOTE_ACCESS", line 44
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_ISCHED_REMOTE_ACCESS", line 25
ORA-06512: at line 2
dbms_isched_remote_access.filewatch_request_resend(hostname IN VARCHAR2)
RETURN BOOLEAN;
BEGIN
IF dbms_isched_remote_access.filewatch_request_resend('PERRITO5') THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/
F
dbms_isched_remote_access.dbms_isched_remote_access.submit_job_results(
job_name IN VARCHAR2,
job_subname IN VARCHAR2,
job_owner IN VARCHAR2,
start_date IN TIMESTAMP WITH TIME ZONE,
run_duration IN INTERVAL DAY TO SECOND,
cpu_used IN INTERVAL DAY TO SECOND,
error_number IN NUMBER,
error_text IN VARCHAR2,
output_text IN VARCHAR2,
request_id IN NUMBER,
add_info IN VARCHAR2,
logging_level IN NUMBER,
store_output IN NUMBER,
std_err_length IN NUMBER,
std_out_length IN NUMBER);
dbms_isched_remote_access.submit_job_results2(
agent_host IN VARCHAR2,
job_results IN VARCHAR2,
nonce IN VARCHAR2,
current_date IN VARCHAR2,
agent_name IN VARCHAR2);
dbms_isched_remote_access.unregister_agent(
agent_host IN VARCHAR2,
agent_name IN VARCHAR2,
current_date IN VARCHAR2,
nonce IN VARCHAR2,
hash IN VARCHAR2);