Home » RDBMS Server » Security » Which role should i give to user to load data
Which role should i give to user to load data [message #73084] Sat, 31 January 2004 06:20 Go to next message
Sonali
Messages: 3
Registered: May 2002
Junior Member
Which role should i give to user to load data through
sql loader

i do not want to give dba right to user

Pl help
Re: Which role should i give to user to load data [message #73089 is a reply to message #73084] Mon, 02 February 2004 03:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
you dont need DBA right to the user.
the owner of the table ( or the schema) can by default load the table. the regular insert/delete privs will apply.
Re: Which role should i give to user to load data [message #73091 is a reply to message #73084] Mon, 02 February 2004 03:20 Go to previous message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Hi,

It depends on what you want SQL*Loader to do. You would typically require the CREATE SESSION and CREATE TABLE privileges. If you want, you can create a role for this:

SQL> CREATE ROLE loader_role;
Role created.

SQL> GRANT create session TO loader_role;
Grant succeeded.

SQL> GRANT create session TO loader_role;
Grant succeeded.


Best regards.

Frank
Previous Topic: How to add custome level security
Next Topic: grant?
Goto Forum:
  


Current Time: Mon Nov 29 17:02:43 CST 2021