Home » RDBMS Server » Server Utilities » Sqlloader password encryption
Sqlloader password encryption [message #646289] Thu, 24 December 2015 03:56 Go to next message
rohit_shinez
Messages: 138
Registered: January 2015
Senior Member
Hi All,

i need to encqrpt the password while connecting to DB where i am using in shell script, is there a way to encrypt the password

sqlldr userid=user/<password>@DBcontrol=/path/load.ctl
Re: Sqlloader password encryption [message #646291 is a reply to message #646289] Thu, 24 December 2015 04:09 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
For this I would use O/S authentication.
Re: Sqlloader password encryption [message #646292 is a reply to message #646289] Thu, 24 December 2015 04:22 Go to previous messageGo to next message
rohit_shinez
Messages: 138
Registered: January 2015
Senior Member
Sorry sqlplus / is not allowed to connect and how will i come to know which user and DB to be connected.
Re: Sqlloader password encryption [message #646294 is a reply to message #646289] Thu, 24 December 2015 04:23 Go to previous messageGo to next message
Michel Cadot
Messages: 67223
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://www.orafaq.com/forum/mv/msg/189636/596649/#msg_596649
http://www.orafaq.com/forum/mv/msg/166739/493198/#msg_493198



Re: Sqlloader password encryption [message #646295 is a reply to message #646292] Thu, 24 December 2015 04:24 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
What do you mean "not allowed to connect"? You will know which user by their O/S username.
Re: Sqlloader password encryption [message #646297 is a reply to message #646289] Thu, 24 December 2015 04:42 Go to previous messageGo to next message
rohit_shinez
Messages: 138
Registered: January 2015
Senior Member
actually is there a way to encrpyt the password while establishing the connection ??

sqlldr userid=user/<encrypted>@DB

Re: Sqlloader password encryption [message #646298 is a reply to message #646297] Thu, 24 December 2015 04:44 Go to previous messageGo to next message
Michel Cadot
Messages: 67223
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Did you read the link I gave you?
They give the solutions for this question.

Re: Sqlloader password encryption [message #646300 is a reply to message #646297] Thu, 24 December 2015 04:48 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
No. Read Michel's links.
Re: Sqlloader password encryption [message #646318 is a reply to message #646300] Thu, 24 December 2015 15:45 Go to previous messageGo to next message
rohit_shinez
Messages: 138
Registered: January 2015
Senior Member
Actually i am not getting how i can hide the password so that no one can't see the actual password basically in encrypt format
Re: Sqlloader password encryption [message #646325 is a reply to message #646318] Thu, 24 December 2015 17:32 Go to previous messageGo to next message
BlackSwan
Messages: 26719
Registered: January 2009
Location: SoCal
Senior Member
https://docs.oracle.com/database/121/SUTIL/GUID-958AD711-DAAA-4185-9055-FD7535CF413D.htm#SUTIL1036
Re: Sqlloader password encryption [message #646327 is a reply to message #646318] Fri, 25 December 2015 06:19 Go to previous message
Michel Cadot
Messages: 67223
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
rohit_shinez wrote on Thu, 24 December 2015 22:45
Actually i am not getting how i can hide the password so that no one can't see the actual password basically in encrypt format


Read again the links and try them, it is clear.

Previous Topic: SQL loader error while using parallel in direct path
Next Topic: exp command ending abruptly without any error messages
Goto Forum:
  


Current Time: Thu Jul 02 18:10:09 CDT 2020