This forum is currently locked. You can't register or post questions at this time. (read more)

How to Hide password

General suggestions and comments about the forums.

Moderator: Tim...

Raaj A
Senior Member
Posts: 51
Joined: Wed Mar 07, 2012 7:08 am

How to Hide password

Postby Raaj A » Fri Dec 21, 2012 1:17 pm

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...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: How to Hide password

Postby Tim... » Fri Dec 21, 2012 2:08 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

Raaj A
Senior Member
Posts: 51
Joined: Wed Mar 07, 2012 7:08 am

Re: How to Hide password

Postby Raaj A » Fri Dec 21, 2012 2:24 pm

Thanks a lot....

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: How to Hide password

Postby Tim... » Fri Dec 21, 2012 2:25 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Suggestions and Comments”

Who is online

Users browsing this forum: No registered users and 3 guests