Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

sqlplus connection and password

Avatar of mahjag
mahjag asked on
Oracle Database
6 Comments1 Solution1184 ViewsLast Modified:
Hi  oracle and unix Gurus
I have an issue where oralce sqlplus is being called from unix k shell. we have our login credentials for sqllplus in our .profile as environment variable defined as
LOGIN=oracle_user/password@oracle_sid; export LOGIN

and this is being used by all the k shells that needs to call sqlplus as in test_call_sqlplus.ksh as
sqlplus -s $LOGIN << EOF
execute <oracle procedure or oracle package.procedure>
EOF

when we execute test_sqlplus.ksh and put them in background and then do
ps -ef |grep tty1 <assuming tty1 is the terminal that is logged in doing this operation>
we see the password showing up as
sqlplus -s oracle_user/password@oracle_sid

This is clear violation as everyone can see the passwd. Is there anyway to hide this info..
ASKER CERTIFIED SOLUTION
Avatar of Franck Pachot
Franck PachotFlag of Switzerland imageOracle DBA

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answers