Home » Infrastructure » Linux » Create a OS user with only sqlloader execute rights
Create a OS user with only sqlloader execute rights [message #271234] Mon, 01 October 2007 00:04 Go to next message
laksha
Messages: 42
Registered: June 2006
Member
RedHat 9 Enterprise linux
Oracle 9.2.0.5

I want to create an OS user which should be able to run OS commands and should be able to use only sqlldr (within oracle binaries).
I am creating this user on the server where oracle database is installed. This is so that the user can use sqlloder and load some flat files to the database table.

Is there any other way to execute this scenario.

Re: Create a OS user with only sqlloader execute rights [message #271255 is a reply to message #271234] Mon, 01 October 2007 00:58 Go to previous message
Michel Cadot
Messages: 59510
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, this is the method but there are several ways to achieve this.
For instance setting others privileges to "rx" on sqlldr, or allowing your user to "sudo" sqlldr, or...

Regards
Michel
Previous Topic: After Export email
Next Topic: how to log in enterprize manager of oracle 10g and access SQL*Pluse on Redhat Enterprise Linux 4
Goto Forum:
  


Current Time: Sat Nov 01 07:37:17 CDT 2014

Total time taken to generate the page: 0.15478 seconds