The Oracle (tm) Users' Co-Operative FAQ

How can I start an SQL*Plus batch without showing the id/password on the command line ?


Author's name: Connor McDonald

Author's Email: connor_mcdonald@yahoo.com

Date written: August 13, 2001

Oracle version(s): 7.3+

How can I start an SQL*Plus batch without showing the id/password on the command line ?

Back to index of questions


This is predominantly a unix-based issue, since anyone with a login account on the server where oracle is running can typically run a 'ps' command and see the user name and password of any sqlplus sessions that are active

Some options you can use to avoid this are:

A C program (hide.c) used to be published on Metalink which would allow you to hide passwords from the process listing. Whilst its probably still there somewhere, its easier to use one of the options presented above.


Further reading: N/A


Back to top

Back to index of questions