Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Plus Question

Re: SQL*Plus Question

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 14 Feb 2002 18:08:38 GMT
Message-ID: <3C6BFD28.93DA34F6@ci.seattle.wa.us>


You are correct I missed it. Either that or was so totally unsympathetic I ignored it. Either way you make a good suggestion though doing so would violate security rules at most companies I have worked at.

Another possibility ... an OPS$ account.

Daniel Morgan

"Howard J. Rogers" wrote:

> 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
> >
Received on Thu Feb 14 2002 - 12:08:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US