Home » RDBMS Server » Server Utilities » SQL*Loader and Seamless login
SQL*Loader and Seamless login [message #368300] Mon, 06 November 2000 15:42 Go to next message
Vinay Sahitya
Messages: 11
Registered: October 1999
Junior Member
The command for sqlldr is userid=aaa/bbb control=xxx.ctl and requires password to be given. However for security reasons our company prohibits hardcoding passwords anywhere in a readable format. Is there a way on unix to get the password from environment or somewhere and substitute?

Thanks
Sumeet
Re: SQL*Loader and Seamless login [message #368309 is a reply to message #368300] Wed, 08 November 2000 08:33 Go to previous messageGo to next message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi
On a user by user basis, you can use OS or External
authentication. For example, you can setup OS_AUTHENT_PREFIX in
your init.ora to be "ops$". You have a Unix account "sumeet". you can
created a database user:

SQL> create user ops$sumeet identified EXTERNALLY;

Now, as long as you are logged into Unix, I can simply:
enter '/' for userid and password. This holds good for sqlplus, sqlldr, exp, imp....etc

$ sqlldr / control=xxx.ctl
Re: SQL*Loader and Seamless login [message #368310 is a reply to message #368309] Wed, 08 November 2000 13:12 Go to previous message
Vinay Sahitya
Messages: 11
Registered: October 1999
Junior Member
Thanks. Let me try this out
Previous Topic: Oracle Database Backup in Network Drive - V.V. Urgent !!!!
Next Topic: SQLLOADER Problem
Goto Forum:
  


Current Time: Sat May 21 04:29:42 CDT 2022