SQL*Loader user priveleges

[oradba101]

Good morning, all

Without assigning the DBA role, what are the minimum privileges needed for a user to use sql*loader. The scenario is that I would like another user to be able to load data into another user's schema but do not want this user to have anything other than the minimal priveleges needed to accomplish this.

Regards,


William Chadbourne
Oracle DBA

 

[LKBrwnDBA]

He would need INSERT/UPDATE/DELETE privilege on the other user's table(s) into which he intends to load data.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[oradba101]

Hi, LKBrwnDBA

The user already has these privileges. The error is:

SQL*Loader-926: OCI error while executing delete/truncate <due to REPLACE/TRUNCATE keyword> for table DBO.CAEMP
ORA-01031: insufficient priveleges

I use the truncate option in SQL*Loader.

Regards,


William Chadbourne
Oracle DBA

 

[LKBrwnDBA]

To be able to TRUNCATE another user's table, he needs this privilege:

GRANT DROP ANY TABLE TO TheUser;

Bummer!


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb