Re: Need help in Unix and Oracle's password!
From: <pcser12_at_ed.petech.ac.za>
Date: 30 Sep 93 08:31:07 GMT
Message-ID: <CE5rnw.HG7_at_hippo.ru.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 |
>--------------------------------------------------
Received on Thu Sep 30 1993 - 09:31:07 CET
Date: 30 Sep 93 08:31:07 GMT
Message-ID: <CE5rnw.HG7_at_hippo.ru.ac.za>
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 |
>--------------------------------------------------
Received on Thu Sep 30 1993 - 09:31:07 CET