OraFAQ Forum: Security » Which role should i give to user to load data

Home » RDBMS Server » Security » Which role should i give to user to load data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Which role should i give to user to load data [message #73084]

Sat, 31 January 2004 06:20

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

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

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

Frank Naude
Messages: 4587
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 07:33:06 CST 2025