How to create a user

Hello Everybody,

Iam new to Oracle database administration Can anybody over here tell me how to create an Oracle User in 8i

Thank you

Hi sanga,

Login in as sys or system the default password when you install oracle are as follows

sys -> change_on_install

system -> manager

Once you connect as the above user just type the following statements

create user username identified by password default tablespace user temporary tablespace temp;

grant connect,resource to username;


The second statement is used to give the user privilege to create objects in the tablespace user

Hope this helped

Regards

Hi sanga,

1) Log into sqlplus using system/manager(default password) to the database.

2) CREATE USER USR1 IDENTIFIED BY PASSWD
DEFAULT TABLESPACE TS_USERS
TEMPORARY TABLESPACE TS_TEMP;

3) GRANT CONNECT, RESOURCE TO USR1


If you want the user to create objects on the other tablespaces , then give him his quota on the other ts as

alter user usr1
quota 50M on ts_users2
;


If you want the user to change his password on his first login then

alter user usr1
password expire;

If you want to drop the user, along with the objects created by him

drop user usr1 cascade;

Hope this helps
Badrinath

Hi,

In Oracel 7.3 & 8 you can also create user and grant privi. to user in one statement :

sqlplus > grant connect, dba, resource to user identified by password;

This will create the user as well as grant privi. I have not tried this on oracle 8i. but it
should work.

Deval

[Edited by Deval on 05-31-2001 at 04:36 PM]

Hi Sanga,

1) Log into the database (using sqlplus) as a DBA user (you can use system/manager).

2) issue the statement:
CREATE USER name IDENTIFIED BY password
DEFAULT TABLESPACE tools
TEMPORARY TABLESPACE temp
quota 10m on tools;

3) Then grant whatever prviliges need to that user:
GRANT CONNECT TO name;
GRANT RESOURCE TO name;

hth,
Helmut