error fetching data using Oracle Enterprise stage

priyadarshikunal · Post by **priyadarshikunal** » Mon Jun 11, 2007 8:12 am

do we need to grant Select privilage to sys.dba_extents while fetching data using Oracle enterprise stage and why?

Because I can fetch the data using ODBC stage but while fetching data from Oracle enterprise stage i am getting an error like

Code: Select all

 

Error executing View Data command:

##E TDOR 000172 17:47:30(001) <Oracle_Enterprise_0> Access to sys.dba_extents  required but not available. Please see your dba for select privileges.

and do we need to grant privilages in DataStage 8 EE while using connector Stage or Oracle enterprise stage?

DSguru2B · Post by **DSguru2B** » Mon Jun 11, 2007 8:14 am

Yes you do. This has been discussed many times before. Search on the error message.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 11, 2007 3:48 pm

There are eight system tables to which you require SELECT privilege. It helps to remind the recalcitrant DBA that you can not do any damage with only SELECT privilege.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 12, 2007 3:23 pm

Now that you've copied the relevant section, there's no need to read the Parallel Job Developer's Guide !

priyadarshikunal · Post by **priyadarshikunal** » Thu Jun 14, 2007 1:21 am

thaks to all of u !!!

I have sent a request to DBA for the SELECT privilege.

regards