ORA-27476 Credential does not exist.txt
пятница, 9 октября 2015 г.
Оставить комментарий
I ran job under user "TEST":
dbms_scheduler.create_job(job_name => v_job_name,
job_type => 'EXECUTABLE',
...
);
dbms_scheduler.set_attribute(v_job_name, 'destination', 'SYS.TEST_DESTINATION');
dbms_scheduler.set_attribute(v_job_name, 'credential_name', 'SYS.TEST_CREDENTIAL');
dbms_scheduler.set_attribute (v_job_name, 'logging_level', DBMS_SCHEDULER.LOGGING_RUNS);
dbms_scheduler.enable(v_job_name);
And I got the errror:
ORA-06512: at "SYS.DBMS_ISCHED", line 4395
ORA-06512: at "SYS.DBMS_SCHEDULER", line 2803
ORA-27476: "SYS.TEST_CREDENTIAL" does not exist
Cause: User "TEST" not have permissions to execute credential.
Action: User "TEST" had the following rights:
GRANT EXECUTE ON SYS.TEST_CREDENTIAL TO TEST;
0 коммент. »
Оставьте Ваш комментарий