sqlplus string to connect with out showing in ps command

[Ariel Cary]

The best way to prevent ps from showing your password is to user externally authenticated users in the database. Basically, the OS authenticates you not the database. Take a look at http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/users.htm#17308.

Then you do

acary@srv> sqlplus /

SQL*Plus: Release 9.2.0.6.0 - Production on Fri Jul 1 10:22:44 2005

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production

SQL> sho user
USER is "OPS$ACARY"
SQL>

It also works on 8i.

Regards,

ARC

[Ariel Cary]

be sure to set remote_os_authent=false (which is the default in 8i, 9i) to prevent undesired access from remote clients.

ARC