Insufficient Privileges Error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bi_fujitsu
Premium Member
Premium Member
Posts: 46
Joined: Tue Mar 20, 2007 3:30 am
Location: India

Insufficient Privileges Error

Post by bi_fujitsu »

I have a job running successfully when run individually. But when I run the same job in sequence, it gives me an error 'Insufficient privileges'.
I am loading data from a dataset to an oracle table.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

... to which table you lack sufficient privileges for loading.

Only your Oracle DBA or the owner of the table can help - we can not.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Simply running it via a Sequence job won't cause this error. Ensure you're still passing the correct parameters to the job.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Shabnam
Participant
Posts: 17
Joined: Thu Mar 10, 2005 2:06 am

Post by Shabnam »

Are you using the same user credentials in both the cases?

Thanks
Shabnam
Post Reply