should have bought the blue!!!
At 12:04 PM 3/28/03 -0800, you wrote:
Privileges should be granted to the user, who created the job.
Was it system?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March
Privileges should be granted to the user, who created the job.
Was it system?
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, March 28, 2003 2:13 PM
I changed the job_queue_processes (thanks
Yes. System is the job owner/creator.
Terry Ball, DBA
Birch Telecom
Work: 816-300-1335
FAX: 816-300-1800
-Original Message-
Sent: Friday, March 28, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
Privileges should be granted to the user, who created the job.
Was it system?
That did not help. It takes longer to error out, but it is still failing. I can set
the same jobs up for the sys user and they run without problems. I am not sure why
the system user is the owner of the jobs and since I am the only DBA here this
afternoon, I will have to wait until next week
Title: RE: Followup to jobs not running
login as sys and grant analyze any table to system.
Raj
-
Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal.
QOTD: Any clod can have facts, having
You may have already got the answer, but if your job is selecting candidate
tables or schemas from dba_tables or dba_???, then you have to grant
select on them to system specifically. System gets the select privilege from
the role DBA and not directly.
I have a similar job that runs under a