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

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

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

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Tue, 02 Jan 2001 20:56:04 -0000
Message-Id: <10729.125548@fatcity.com>


Which is why I used to teach a seminar called DBA 101: A Refresher Course :)

>From: Jeffery Stevenson <jeff_at_mpv.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: OT: RE: how to create new user for the newly created databse.
>Date: Tue, 02 Jan 2001 11:45:33 -0800
>
> Well, sometimes the high-level dbas can get so distracted with all the
>high-level stuff that they tend to get "rusty" with some of the basics...a
>good refresher every now and then doesn't hurt. :)
>
>Jeffery Stevenson
>Chief Databeast Tamer
>Medical Present Value, Inc.
>Austin, TX
>
>-----Original Message-----
>Sent: Sunday, December 31, 2000 4:10 AM
>To: Multiple recipients of list ORACLE-L
>databse.
>
>
>Dear Alex
>
>U R right
>
>Yes ! this list was once for medium range to high range DBAs
>
>Now it is reduced to dontknowwheretostartdba.com
>
>I appreciate Diana, Lisa, Malladi, Jarred for their patience
>
>As U said some might leave this list as they can't afford to waste
>their time going through basics
>
>Rao
>
>--
>
>On Fri, 29 Dec 2000 09:46:46
> Hannah.M.Doran wrote:
> >
> >
> >
> >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:
> >
> >
> >
> >
> >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
> >also send the HELP command for other information (like subscribing).
> >
> >
> >
> >
> >
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author:
> > INET: Hannah.M.Doran_at_sb.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).
> >
>
>
>Get FREE Email/Voicemail with 15MB at Lycos Communications at
>http://comm.lycos.com
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: aaaa wwwwww
> INET: krisibm_at_lycos.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: Jeffery Stevenson
> INET: jeff_at_mpv.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 Tue Jan 02 2001 - 14:56:04 CST

Original text of this message

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