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

OR...
Follow the link at the bottom of each email to http://www.orafaq.com and look in the faq. There's a lot of info there.

--Scott

> -----Original Message-----
> From: Joseph S. Testa [SMTP:teci_at_oracle-dba.com]
> Sent: Friday, December 29, 2000 10:36 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: how to create new user for the newly created databse.
>
> 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 :)
>
>
> joe
>
>
> > 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 [mailto:teci_at_oracle-dba.com]
> > 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
> > > 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 http://www.oracle-dba.com
> No you can't fix an ORA-600 error, call Oracle Support.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joseph S. Testa
> INET: teci_at_oracle-dba.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Fri Dec 29 2000 - 11:15:11 CST