Home » RDBMS Server » Server Utilities » Hiding password in exp command (Oracle 10G)
Hiding password in exp command [message #443059] Fri, 12 February 2010 05:44 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 63802
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
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
Previous Topic: Import from one tablespace to another
Next Topic: sqlrd control file
Goto Forum:
  


Current Time: Sun Sep 25 21:29:19 CDT 2016

Total time taken to generate the page: 0.12225 seconds