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

I dont mind these *stupid* questions as you say. You don't always know what is happening with the person posing the question. Perhaps they were thrown into the job due to someone leaving and do not even know where to start. Maybe the manuals aren't there....

Ok, granted, I'd know enough to go to the Oracle site and download the docs, or look at the FAQ or even buy a book. But you never know. Maybe the poster wouldn't even mind a response that just TELLS them where to look.

If you dont want to answer the question, then dont. But I wouldn't want to discourage people from posting to this fabulous list. Especially newbies!

Scott.Shafer_at_dcpds.cpms.osd.mil on 12/29/2000 12:16:46 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: 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
> also send the HELP command for other information (like subscribing).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

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