Re: add new user to oracle ??

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 30 Jan 2004 08:00:56 -0800
Message-ID: <1075478399.300613@yasure>

Cookie Monster wrote:

> "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.

Sorry cookie monster ... but given the OPs question your response will likely cause problems. Let me suggest a modfication:

log on as SYS
identify available tablespaces

SELECT tablespace_name
FROM dba_tablespaces
WHERE tablespace_name NOT IN ('SYSTEM','TEMP', 'RBS', 'UNDOTBS1');

3. create user

CREATE UESR <user_name>
IDENTIFIED BY <password>
DEFAULT TABLESPACE <tablespace_returned from the above query> TEMPORARY TABLESPACE temp
QUOTA 0 ON SYSTEM
QUOTA <unlimited | 10M> ON <tablespace_returned from the above query>;

GRANT create session TO <user_name>;
GRANT <other_privileges> TO <user_name>;

Do not grant the CONNECT, RESOURCE, OR DBA roles. Learn the sysystem privileges and grant those required.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Jan 30 2004 - 10:00:56 CST