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

Home -> Community -> Usenet -> c.d.o.tools -> Re: how to set up oracle user ( begginer question)

Re: how to set up oracle user ( begginer question)

From: Jan Kucharski <jkucharski_at_altavista.net>
Date: Tue, 29 Aug 2000 08:50:57 +0100
Message-ID: <MPG.14157bc0e51aea69989689@news.demon.co.uk>

In article <39A6725A.9050504_at_totalise.co.uk>, maxsec_at_totalise.co.uk says...
> jkucharski_at_altavista.net wrote:
>
> > Hi,
> >
> > I have an oracle database on solaris installed by oracle user.
> >
> > Now how can I create a new user who will be able to execute only certain
> > commands from /oracle..../bin ( e.g. run sqlplus )
> >
> > Is it better to create a group which will have these provileges ( how ) ?
> > An then assign a user to this group ?
> > I already have a group called DBA ( but this group is too powerfull for
> > the new user to be in ).
> >
> > This user also has to have the PATH to be set up ( i think .profile will
> > take care of it ).
> >
> > I am quite ignorant at the moment how to do this.
> >
> > Please any suggestions and pointers to books will be appreciated.
> >
> > Thanks
> > Jan
> > jkucharski_at_altavista.net
> >
> Hi
>
> as a previous poster has pointed out..there are two ways of accesssing
> Oracle.
>
> 1) login to Unix then access Oracle using a completely seperate Oracle
> Account.
>
> 2) from A.N.Other machine and login directly to Oracle without touching
> Unix login.
>
> Assuming 1) is how your user will be operating then just make sure
> $ORACLE_HOME/bin is in the path and $ORACLE_HOME/lib is in the
> $LD_LIBRARY_PATH.
>
> Martin
>
>

Thanks for all that replied.
Now I can start working as usual.
:-)

Jan. Received on Tue Aug 29 2000 - 02:50:57 CDT

Original text of this message

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