Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to create new user for the newly created databse.

Re: how to create new user for the newly created databse.

From: Joseph S. Testa <>
Date: Fri, 29 Dec 2000 11:34:33 -0500
Message-Id: <>

point well taken, hence my original answer to the question was:

you want to use the create user command, break out the docs and look it up.

Kinda like the fish concept, give a man a fish, he'll be back to have him give you more, teach him to fish and he becomes self-sufficient(badly paraphrased), but the concept is the same, if you make someone look up create user, maybe if they are reading the docs, they'll see create table before that and learn something about storage, we can always hope :)


> Alex Hillman wrote:
> I wonder, if it is possible to do database administration using this
> list as a source for answers for most basic questions without reading
> any docs or going to web for docs. Soon we will get questions like I
> have in my hand CD with Oracle, what I should do with it. And some
> people will seriously answer these questions. What the sence to
> discuss roles, unlimited tablespace privileges etc. if this guy/gal
> hasn't any ideas what these words mean or how to find what these words
> mean. It is only to invite more such cluless questions. Again, this is
> my observation (without pointing to specific groups) that level of
> cluelesness (not sure about spelling) on this list increased
> considerably in last couple of months. It looks more and mor like
> lazydba list. What I am afraid is people with knowledge will leave (as
> Steve Adams did when he left lazydba list). I do not know what is the
> solution to this problem.
> Alex Hillman
> -----Original Message-----
> From: Joseph S. Testa []
> Sent: Friday, December 29, 2000 8:46 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: how to create new user for the newly created databse.
> Ok why grant resource, those roles will eventually go away, mirate
> away
> from them, besides its a bad move, when you grant resource they get
> unlimited tablespace, which lets them create objects whereever they
> want
> INCLUDING system tablespace, NO one needs resource, grant them the
> specific privileges.
> joe
> Srinivas Rao Pulla wrote:
> >
> > svrmgr> create user USERID identified by PASSWORD default
> tablespace
> > svrmgr> grant create session, resource to USERID;
> >
> > Thanks
> > Srinivas
> >
> > siva wrote:
> >
> > > hi all,
> > > Thanks in advance.
> > > how to create new user for the newly created database..
> > >
> > > with regards,
> > > siva

Joe Testa
Received on Fri Dec 29 2000 - 10:34:33 CST

Original text of this message