DSXchange

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

Posted: **Fri Mar 02, 2007 9:08 am**

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

Posted: **Fri Mar 02, 2007 10:34 am**

Requirements are in the documentation.

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

DSXchange

requirements for using oracle stage in parallel jobs

requirements for using oracle stage in parallel jobs