Re: Hiding username/password from ps

The two different ps commands appear to have been run in different environments or different systems. I recall that some Sequent systems had a patch to ps to exclude oracle username passwords, but it was the version of ps that made the difference, not the version of sqlplus. You will run into this problem with all other tools that require the username / password passed on the command line. As I believe has already been posted, a potential solution is a front end for ps that strips the username / password from sql entries.

Good Luck,

Mark Nielsen
Consultant

Scott Buennemeyer <buenneme_at_fsl.noaa.gov> wrote:

>I just did a ps on my system while connected to sqlplus with
snip

>Don Brown wrote:
>
> My version V6.0.36.0.1 of sqlplus doesn't display the uid/passwd on the
> command line:
>
> sqlplus scott/tiger
>
> from another shell:
> ps -aux | grep sql
> don 3182 0.0 0.2 32 208 p0 S 15:34 0:00 grep sql
> don 3179 0.0 0.5 184 488 p1 S 15:34 0:00 sqlplus
>
> My version 7.0.16.6.0 sqlplus, however, does:
> ps -ef | grep sql
> don 4416 4401 3 15:37:13 pts/1 0:00 grep sql
> don 4412 4383 24 15:36:56 pts/0 0:00 sqlplus scott/tiger
>
> I don't know why I get this behavior, but I do. Perhaps the version 6
> sqlplus has been patched so it doesn't show the arguments.
>
> Don
> Boeing Computer Services, Richland
> (509) 376-6990
> don_brown_at_rl.gov
Received on Wed Dec 27 1995 - 00:00:00 CET