Re: newbie question

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Wed, 02 May 2001 13:39:06 GMT
Message-ID: <_5UH6.95530$xN4.6452549@news1.sttls1.wa.home.com>

Standard sql (I am assuming you want to allow other users on the same machine ot log in).
create user aUserName identified by theirPassword; then you have to grant them rights
grant connect to aUserName;
grant select on emp to aUserName;
....

I believe there may be a GUI for this also.

Jim

"Chris ( Val )" <XCHRISVAL_at_bigpond.com.au> wrote in message news:HaSH6.16225$482.82565_at_newsfeeds.bigpond.com...
> Hi everybody, I've just installed Oracle Personel
> edition 8i for the first time, I followed all the instructions
> in the readme file and got it set up and tested fine on
> my machine Win98 SE.
>
> What I would like to know is this:
> Is it possible to add a new user account with the personel
> edition of 8i?
> I have looked everywhere but cannot find anywhere where
> to do this, I did a typical install as the readme file suggested
> so is it also possible that the administration part for adding
> user accounts was not installed by doing this?
>
> All and any help truely appreciated.
> Chris
>
>
>
>
>
Received on Wed May 02 2001 - 08:39:06 CDT