Re: Need help in Unix and Oracle's password!

In article <CE5rnw.HG7_at_hippo.ru.ac.za>, pcser12_at_ed.petech.ac.za writes:
|>In article <287ohu$481_at_cville-srv.wam.umd.edu> jiun_at_wam.umd.edu (Jiun H. Lai) writes:
|>>Hi...
|>>
|>>Can anyone of you tell me how to use unix password as oracle password when
|>>I login to unix system so I can get into sqlplus or sqlmenu without typing
|>>the password twice?
|>>I think Couple of months ago somebody talk about this I couldn't remember
|>>what they said.
|>>
|>>Thanks in advance.
|>
|>when creating your Oracle user use the following statment
|>
|> GRANT CONNECT TO ops$username
|> IDENTIFIED BY passwd;
|>
|> (eg : grant connect to ops$darryl identified by test;)
|>
|> darryl must be a user defined on your system before you
|> try to do this. What then happes is when you log on as that
|> user id all you have to do is type " sqlplus / " at your
|> prompt and this will log you on to the database.
|>
|> Hope this help's
|>
|> Darryl de Klerk
|> System's Administrator
|> Port Elizabeth Technikon
|> South Africa
|> pcser1_at_ed.petech.ac.za
|>>
|>>Jiun
|>>
|>>--
|>>Jiun H. Lai | jiun_at_wam.umd.edu |
|>>University of Maryland | ucjiun_at_socrates.umd.edu |
|>>College Park | ucjiun_at_umuc.umd.edu |
|>>--------------------------------------------------
|>

Darryl, I think the user CAN NOT be defined on the system if I want they can only access the database. I have this type of users. In this case I can't enregister these users like :

          grant connect to ops$x identified by values 'x'; because they have to type their password. And then they are enregistered like indicate by you. Bye!

-- 
------------------------------------------------------------------------------
    _/_/_/_/    _/_/_/_/   _/_/_/_/   _/_/_/_/                  I use
   _/_/          _/_/       _/_/       _/_/               ORACLE v6.0.36.5.2
  _/_/          _/_/       _/_/       _/_/                        on        
 _/_/_/_/ .  _/_/_/_/ .   _/_/ .   _/_/_/_/ .            DEC RISC ULTRIX v4.3
------------------------------------------------------------------------------
Yves NOEL   -   Database Administrator
C.I.T.I. (batiment M4)                             Phone : (33)  20.43.42.70
Universite des Sciences & Technologies de Lille    Fax   : (33)  20.43.66.25 
59655 Villeneuve d'Ascq Cedex - FRANCE             Email : noel_at_univ-lille1.fr
------------------------------------------------------------------------------