Database Administration (MOSC)

MOSC Banner

ORA-27486:insufficient privileges

edited Aug 26, 2013 6:18AM in Database Administration (MOSC) 6 commentsAnswered
hello,
I have version 11.2.3 in linux

I test a procedure but show me these messages:


ORA-06512: en "SYS.DBMS_ISCHED", línea 579
ORA-06512: en "SYS.DBMS_ISCHED", línea 646
ORA-06512: en "SYS.DBMS_SCHEDULER", línea 1438

I grants these provileges:

GRANT CREATE JOB TO user
GRANT CREATE ANY JOB TO user
GRANT EXECUTE ON sys.DBMS_SCHEDULER TO  user
GRANT EXECUTE ON sys.DBMS_ISCHED TO  user


But the function don't work.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center