requirements for using oracle stage in parallel jobs

kirankota79 · Post by **kirankota79** » Fri Mar 02, 2007 9:07 am

please tell me whether it is compulsory to have a select privilege for the following to use an oracle stage:

DBA_EXTENTS
DBA_DATA_FILES
DBA_TAB_PARTITONS
DBA_OBJECTS
ALL_PART_INDEXES
ALL_PART_TABLES
ALL_INDEXES

bcoz......when i used this stage, it is giving an error that it needs the privilege on "sys.dba_extents". can anybody of you give me exact requirements?

DSguru2B · Post by **DSguru2B** » Fri Mar 02, 2007 9:08 am

Its mandatory. It has been discussed here before. Search....

chulett · Post by **chulett** » Fri Mar 02, 2007 10:34 am

Requirements are in the documentation.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 02, 2007 2:33 pm

Indeed, all of those and, depending on circumstances, one or two others as well. You will probably have to convince your DBA that SELECT privilege does not allow anyone to do any damage.