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

Hi ,
My name is Sam Roberts - Oracle DBA (previously DB2) working in Middle East. I used to read this List about 2-3 years ago and learn a bit - Ive just re registered and either my knowledge is extremely more than it was back then or the questions have just got easier ( bit of both I guess) - but there is a real danger of people claiming to be DBA's who are totally not qualified ( see Gartner reports ), but what to do.

Anyhow , I'm studying my Masters and for my dissertation I'm looking for extremely badly written SQL ,especially out of ERP packages like SAP,ORACLE FINANCIALS, MAXIMO etc... also, I'm sure you DBA'S have come across many cowboy programmers who would have provided you with some real howlers to optimize.I certainly have and I could share.

If anybody can pass on any gems, I would be extremely grateful.

I will also recognize you in my paper,

Thanks and I hope some people out there share my sense of humor on this one

Sam Roberts

-----Original Message-----
From: Jeffery Stevenson [mailto:jeff_at_mpv.com] Sent: Tuesday, January 02, 2001 11:46 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT: RE: how to create new user for the newly created databse.

  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