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, Ma
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 diff
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 an
[EMAIL PROTECTED] Subject: Follow
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"?
I
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 B
I changed the job_queue_processes (thanks Barbara), and the jobs all started running,
but they are not successful from within the job_queue. They are jobs to gather schema
stats using dbs_stats and are run as the system user. I can run the what of the jobs
within sqlplus successfully, but whet