Re: [Newbie] : SQL*Plus and users

Sébastien wrote:
>
> I have the user "oracle" on my solaris 2.6 machine, he is part of the
> sys/dba group, so, of course, he has access to sqlplus. I've got another
> user called "seb" (/export/seb) who is a member of the group user and
> doesn't have access to SQL*plus. How can I notify that the group "user"
> can also use SQL*Plus ? by simply copying the binary file into
> export/seb or is there any other way ?

in the user's login (.cshrc, .profile, etc.) set ORACLE_HOME and ORACLE_SID
enviromentals and make sure that $ORACLE_HOME/bin is in the path.

normally, that should do it.

--
*--------------*-----------------------------------------------*
| Andrew Allen | DBA                                           |
|              |   Process Leadership / PSL, Dearborn, MI USA  |
 * Definitions: *-----------------------------------------------*
|Science        : Looking for a black cat in a dark room.      |
|Philosophy     : Looking for a black cat in a dark room where |
|                 there is no cat.                             |
|Psycho Analysis: Looking for a black cat in a dark room where |
|                 there is no cat and finding one anyway       |
*--------------------------------------------------------------*