OraFAQ Forum: Server Utilities » Hiding password in exp command

Home » RDBMS Server » Server Utilities » Hiding password in exp command (Oracle 10G)

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

Hiding password in exp command [message #443059]

Fri, 12 February 2010 05:44

explorer8
Messages: 3
Registered: February 2010

Junior Member

Hi All,
I am not an Oracle DBA, just a user. So keeping that in mind, let me ask a question on hiding the password while running exp command.

I have a shell script with simple exp command. I have specified my userid and password in a variable and stored on UNIX Home dir with access is 700 (Only user can see it).

Now if I run my shell script to exp the db and try to open another instance of Putty and see all processes, I can see exp process running with my password.

How do I hide my password while running exp command in a shell script?

Thanks in advance.

[Updated on: Fri, 12 February 2010 05:47] by Moderator

Report message to a moderator

Re: Hiding password in exp command [message #443060 is a reply to message #443059]

Fri, 12 February 2010 05:48

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

Senior Member
Account Moderator

Use Secure External Password Store.

Regards
Michel

[Updated on: Fri, 12 February 2010 05:48]

Report message to a moderator

Re: Hiding password in exp command [message #443063 is a reply to message #443060]

Fri, 12 February 2010 06:19

explorer8
Messages: 3
Registered: February 2010

Junior Member

Thanks Michel.

This is what I found on asktom.oracle.com and exactly what I was looking for

print mypassword | exp userid@dbname ..... other options .....

Cool

Report message to a moderator

Previous Topic:	Import from one tablespace to another
Next Topic:	sqlrd control file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 23:08:15 CST 2025