Oracle err when using PX and no error when using Server job

[richdhan]

Hi,

I created a simple PX job where I retrieve data from Oracle.
I imported the table definition and I provided all the connection parameters and when I clicked on the view data button I get the following
error

Access to sys.dba_extents required but not available.

I created the same job as a Server job and Iam able to view the data.

Your help would be appreciated.

Thanks
Rich

[Eric]

I expect the Server job does not require Access to sys.dba_extents.

Have you check your permissions within Oracle?

[nkumar_home]

What are the options you have selected for Source and Connection.

Have you selected "Partition Table"? If so PX needs to be able to read some of the sys tables to get partition information.