DSXchange

Posted: **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?

Posted: **Mon Jun 11, 2007 8:14 am**

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

Posted: **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.

Posted: **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 !

Posted: **Thu Jun 14, 2007 1:21 am**

thaks to all of u !!!

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

regards

DSXchange

error fetching data using Oracle Enterprise stage

error fetching data using Oracle Enterprise stage