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.

Report message to a moderator

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: 68641
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

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 10:38:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.