Re: SQL*Plus Question

Daniel must have missed the bit about you not wanting to type in your password each time.

So here's my suggestion. Forget about all those environment variables. In the directory where you usually load SQL Plus from, create a new text document called login.sql -in there, you can put a number of things, such as:

set pagesize 2000
set linesize 132
connect system/manager_at_db1

...or, in your case, connect me/password_at_server.

When you then run "sqlplus /nolog", the login.sql script is automatically executed for you. Voila... connected, and no password typing necessary. You might want to then experiment with chmodding (and conceivably chowing it, too) the script so that a nefarious user can't simply view it and discover your password, but sqlplus has no trouble using it.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"damorgan" <dan.morgan_at_ci.seattle.wa.us> wrote in message
news:3C6B24DA.9E472AF1_at_ci.seattle.wa.us...


> Why are you doing step 1? It it totally unnecessary.

>

> Just start SQL*Plus and enter the user/passwd_at_server at the prompt.

>

> Daniel Morgan

>

>

>

> kv wrote:

>

> > Hi

> > I am on Sun-Solaris Oracle 8i.

> >

> > To log into SQL*Plus, usually I do the following:

> >

> > 1)     define export variables for user, passwd and server

> > 2)      sqlplus $user/$passwd@$server

> >

> > The problem with this approach is, as long as the SQL*Plus session is

> > active, If any body does a ps-ef on the system, they will see my schema

> > password. How can I prevent any body seeing my password and still be

able to


> > use the export variables to login to SQL*Plus.  I donot want to enter

pass


> > word everytime I log into SQL*Plus?

> >

> > Thanks

> > Krishna

> > Email: krishna_vemulapalli_at_hotmail.com

>