-
Hello Everybody,
Iam new to Oracle database administration Can anybody over here tell me how to create an Oracle User in 8i
Thank you
sanga
-
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
Santosh
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|