Re: add new user to oracle ??

"raf" <legendr_at_poczta.onet.pl> wrote in message news:bvdtov$gre$1_at_news.lublin.pl...
> Hi I'm new guy a I don't now how to do this
> Please help me ;-) !!!
>

create user fred identified by password
temporary tablespace temp
default tablespace mydata
quota 10M on mydata

You need to replace the temp and default tablespaces with your own.

check:

select * from dba_tablespaces;

Cookie.

>
Received on Fri Jan 30 2004 - 09:42:54 CST