Home » RDBMS Server » Server Administration » Job scheduler issue (RDBMS 11G2 linux)
Job scheduler issue [message #626387] Mon, 27 October 2014 09:19 Go to next message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
Hi all

trying to run a purge job as sysdba and keep getting "insufficient privileges", I don't know how to correct the issue
Many thanks


SQL> begin
test.data_purge.executeJob;
test.data_purge.executeJobCust;
test.data_purge.executeJobAudit;
commit;
end;
/
2 3 4 5 6 7 begin
*
ERROR at line 1:
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 124
ORA-06512: at "SYS.DBMS_SCHEDULER", line 271
ORA-06512: at "test.DATA_PURGE", line 790
ORA-06512: at line 2
SQL> show user
USER is "SYS"
SQL>

Re: Job scheduler issue [message #626391 is a reply to message #626387] Mon, 27 October 2014 09:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ Never do something as SYSDBA when it should be done by someone else. SYSDBA is ONLY for database maintenance. Read SYS is special.

2/ The owner of the package is TEST, so privileges of TEST apply NOT those of SYS.

Re: Job scheduler issue [message #626405 is a reply to message #626391] Mon, 27 October 2014 12:05 Go to previous message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
thanks

let me try it
Previous Topic: Rollback Session
Next Topic: Why does a database imported from a production dump not have the same csscan as the original db
Goto Forum:
  


Current Time: Fri Mar 29 07:12:28 CDT 2024