OraFAQ Forum: Server Utilities » Sqlloader password encryption

Home » RDBMS Server » Server Utilities » Sqlloader password encryption

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Sqlloader password encryption [message #646289]

Thu, 24 December 2015 03:56

rohit_shinez
Messages: 139
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

Report message to a moderator

Re: Sqlloader password encryption [message #646291 is a reply to message #646289]

Thu, 24 December 2015 04:09

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

For this I would use O/S authentication.

Report message to a moderator

Re: Sqlloader password encryption [message #646292 is a reply to message #646289]

Thu, 24 December 2015 04:22

rohit_shinez
Messages: 139
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.

Report message to a moderator

Re: Sqlloader password encryption [message #646294 is a reply to message #646289]

Thu, 24 December 2015 04:23

Michel Cadot
Messages: 68773
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Sqlloader password encryption [message #646295 is a reply to message #646292]

Thu, 24 December 2015 04:24

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

What do you mean "not allowed to connect"? You will know which user by their O/S username.

Report message to a moderator

Re: Sqlloader password encryption [message #646297 is a reply to message #646289]

Thu, 24 December 2015 04:42

rohit_shinez
Messages: 139
Registered: January 2015

Senior Member

actually is there a way to encrpyt the password while establishing the connection ??

sqlldr userid=user/<encrypted>@DB

Report message to a moderator

Re: Sqlloader password encryption [message #646298 is a reply to message #646297]

Thu, 24 December 2015 04:44

Michel Cadot
Messages: 68773
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: Sqlloader password encryption [message #646300 is a reply to message #646297]

Thu, 24 December 2015 04:48

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

No. Read Michel's links.

Report message to a moderator

Re: Sqlloader password encryption [message #646318 is a reply to message #646300]

Thu, 24 December 2015 15:45

rohit_shinez
Messages: 139
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

Report message to a moderator

Re: Sqlloader password encryption [message #646325 is a reply to message #646318]

Thu, 24 December 2015 17:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

https://docs.oracle.com/database/121/SUTIL/GUID-958AD711-DAAA-4185-9055-FD7535CF413D.htm#SUTIL1036

Report message to a moderator

Re: Sqlloader password encryption [message #646327 is a reply to message #646318]

Fri, 25 December 2015 06:19

Michel Cadot
Messages: 68773
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 17 03:37:42 CST 2025