Original Question:
I would like to hide the ORACLE userid and password that gets
displayed in the command section when using the ps -ef command.
e.g
oracle 18993 1411 0.0 09:51:58 ttyqf 0:00.00 f45run my_form
scott/tiger
Oracle have a program called hide.c which I list below. Unfortunately
this does not work on Digital Unix 4.0B as Digital's ps command will
trim the 3000 spaces that the hide program adds to the command.
Does anyone have any ideas?
Solutions(?):
Thankyou to all those who replied.
Unfortunately, I have not come up with an answer that is completely
satisfactory to our site. I will be asking ORACLE and Compaq direct to
see if they have any suggestions. (ORACLE solve this with sqlplus, so
there must be some way)
Here are the suggestions:
1) Run a shell or C-program wrapper, hiding the username/password in a
file or as environment variables. However our setup demands that the
username/password be provided at the command line.
2) Use ORACLE's OS authentication. Also unsuitable for us.
3)
Makes a mess of your ps listing but this will do it:
ps -ef | sed "s? [a-z]*/[a-z]* ??g"
^ ^
Could be used as a wrapper script, might take some experimenting to
get it right.
Make a script called ps and ensure it is executable by your users, ie.
in the path etc. Make sure the general ps command is no longer
available. Use the $1 - $x subtitutes to pass in flags for the ps:
#!/bin/sh
ps $1$2$3$4$5 | sed ...
The user won't see the username/password any more, they won't see any
pathnames either but just thought I'd mention it. You might be able
to adapt it for your purposes by getting it to match specific
executables?
This is probably the best solution so far for us, however I am
unwilling to modify ps at this stage without searching for a prettier
solution.
Stay tuned...
> Rob Wilson
>
> UNIX System Administrator/ORACLE Database Administrator
> Australian Submarine Corporation
> rawilson_at_subcorp.com.au
Received on Fri Mar 26 1999 - 01:12:45 NZST