OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Job scheduler issue (RDBMS 11G2 linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Job scheduler issue [message #626387]

Mon, 27 October 2014 09:19

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>

Report message to a moderator

Re: Job scheduler issue [message #626391 is a reply to message #626387]

Mon, 27 October 2014 09:30

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Job scheduler issue [message #626405 is a reply to message #626391]

Mon, 27 October 2014 12:05

evoradba
Messages: 144
Registered: April 2005
Location: Canada

Senior Member

thanks

let me try it

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 11:30:06 CST 2025