| SQL*Loader and Seamless login [message #368300] |
Mon, 06 November 2000 15:42  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
