How to Hide password

[Raaj A]

Hi Tim,

Whenever i connect any user through sqlplus, password appears like "sqlplus> connect sys/sys@dbname as sysdba"
i want my password should be hidden like "sqlplus> connect sys/********@dbname as sysdba".

which parameter i should set to hide my password for security reason.

Please help..

Thanks
Raaj

[Tim...]

Hi.

If you are manually logging in, then don't supply your password and you will be prompted for it. This is not shown.

Code: Select all

connect sys@dbname as sysdba

If it is done using a script, then you shouldn't really be connecting remotely like this. You could do this:

http://www.oracle-base.com/articles/mis ... ePasswords

You can always use a password store:

http://www.oracle-base.com/articles/10g ... -10gr2.php

If it is on the same box as the DBA, you can use OS authentication.

http://www.oracle-base.com/articles/mis ... cation.php

Cheers

Tim...

[Raaj A]

Thanks a lot....

[Tim...]