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

Good points!

> I do not know what is the solution to this problem.
You need to pass the LCP test before asking questions... LCP = "List Certified Participant"

> I have in my hand CD with Oracle, what I should do with it.
Put in your boom box, turn the volume way up and press play.

Sighs with commiseration...
Steve Orr

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Alex Hillman Sent: Friday, December 29, 2000 7:16 AM
To: Multiple recipients of list ORACLE-L Subject: RE: how to create new user for the newly created databse.

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
> > --
Received on Fri Dec 29 2000 - 10:59:26 CST