OraFAQ Forum: Server Utilities » Hiding userid/password? anyone.

Home » RDBMS Server » Server Utilities » Hiding userid/password? anyone.

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

Hiding userid/password? anyone. [message #72399]

Mon, 09 June 2003 01:51

mbpgmr
Messages: 2
Registered: June 2003

Junior Member

Hi. anyone out there knows how to hide(encrypt??) userid/password in the sqlldr syntax line?

sqlldr scott/tiger@db ....

in the above case, i want to hide(encrypt) scott/tiger.
Can it be done?

Report message to a moderator

Re: Hiding userid/password? anyone. [message #72402 is a reply to message #72399]

Mon, 09 June 2003 03:33

Rashmi
Messages: 20
Registered: April 2001

Junior Member

Hi,
you can use sqlldr scott@db....

So when u press enter you will be prompted for a password. This way atleast your password will remain hidden.

Report message to a moderator

Re: Hiding userid/password? anyone. [message #72403 is a reply to message #72402]

Mon, 09 June 2003 04:15

mbpgmr
Messages: 2
Registered: June 2003

Junior Member

Yeah...that's one..but i'm gonna schedule this process and it's impossible to get someone to enter the password everytime it triggered.
I am figuring whether i can use hidden file approach i.e calling another hidden file's parameters(username&pwd).

What do u think? Have u heard of this technic?

Report message to a moderator

Re: Hiding userid/password? anyone. [message #72432 is a reply to message #72399]

Fri, 13 June 2003 17:14

Raju Angani
Messages: 5
Registered: June 2003

Junior Member

Put your passwords in a script and call the script(@@Password.sql) in the main script.

It works for me.

Report message to a moderator

Previous Topic:	Filler keyword in SQL Loader Release 7.3.4.4.1
Next Topic:	Archive Logs not deleted

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 06:34:09 CST 2024