Hello Everybody,
Iam new to Oracle database administration Can anybody over here tell me how to create an Oracle User in 8i
Thank you
Printable View
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