| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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.
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C071A8.E95FD720
Content-Type: text/plain;
charset="windows-1252"
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
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: siva
> > INET: siva_oracle2000_at_hotmail.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: Srinivas Rao Pulla
> INET: spulla_at_deploy.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).
-- 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). ------_=_NextPart_001_01C071A8.E95FD720 Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dwindows-1252"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0"> <TITLE>RE: how to create new user for the newly created = databse.</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>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.</FONT></P> <P><FONT SIZE=3D2>Alex Hillman </FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Joseph S. Testa [<A = HREF=3D"mailto:teci_at_oracle-dba.com">mailto:teci_at_oracle-dba.com</A>]</FON= T> <BR><FONT SIZE=3D2>Sent: Friday, December 29, 2000 8:46 AM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: how to create new user for the newly = created databse.</FONT> </P> <BR> <P><FONT SIZE=3D2>Ok why grant resource, those roles will eventually go = away, mirate away</FONT> <BR><FONT SIZE=3D2>from them, besides its a bad move, when you grant = resource they get</FONT> <BR><FONT SIZE=3D2>unlimited tablespace, which lets them create objects = whereever they want</FONT> <BR><FONT SIZE=3D2>INCLUDING system tablespace, NO one needs resource, = grant them the</FONT> <BR><FONT SIZE=3D2>specific privileges.</FONT> </P> <P><FONT SIZE=3D2>joe</FONT> </P> <BR> <BR> <P><FONT SIZE=3D2>Srinivas Rao Pulla wrote:</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> svrmgr> create user USERID identified = by PASSWORD default tablespace</FONT> <BR><FONT SIZE=3D2>> TABLESPACE;</FONT> <BR><FONT SIZE=3D2>> svrmgr> grant create session, resource to = USERID;</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Thanks</FONT> <BR><FONT SIZE=3D2>> Srinivas</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> siva wrote:</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> > hi all,</FONT> <BR><FONT SIZE=3D2>> > Thanks in advance.</FONT> <BR><FONT SIZE=3D2>> > how to create new user for the newly = created database..</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > with regards,</FONT> <BR><FONT SIZE=3D2>> > siva</FONT> <BR><FONT SIZE=3D2>> > --</FONT> <BR><FONT SIZE=3D2>> > Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> > --</FONT> <BR><FONT SIZE=3D2>> > Author: siva</FONT> <BR><FONT SIZE=3D2>> > INET: = siva_oracle2000_at_hotmail.com</FONT> <BR><FONT SIZE=3D2>> ></FONT> <BR><FONT SIZE=3D2>> > Fat City Network = Services -- (858) 538-5051 FAX: (858) = 538-5051</FONT> <BR><FONT SIZE=3D2>> > San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> > = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> > To REMOVE yourself from this mailing list, = send an E-Mail message</FONT> <BR><FONT SIZE=3D2>> > to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> > the message BODY, include a line = containing: UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> > (or the name of mailing list you want to = be removed from). You may</FONT> <BR><FONT SIZE=3D2>> > also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>> --</FONT> <BR><FONT SIZE=3D2>> Author: Srinivas Rao Pulla</FONT> <BR><FONT SIZE=3D2>> INET: spulla_at_deploy.com</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Joe Testa <A = HREF=3D"http://www.oracle-dba.com" = TARGET=3D"_blank">http://www.oracle-dba.com</A></FONT> <BR><FONT SIZE=3D2>No you can't fix an ORA-600 error, call Oracle = Support.</FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Joseph S. Testa</FONT> <BR><FONT SIZE=3D2> INET: teci_at_oracle-dba.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT>Received on Fri Dec 29 2000 - 09:06:19 CST
 |
 |