, ,

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 коммент. »

Оставьте Ваш комментарий