oracle query [message #1071] |
Wed, 27 March 2002 04:54 |
Nitesh Shah
Messages: 1 Registered: March 2002
|
Junior Member |
|
|
Can you please tell me how do i create an user in oracle.That means what is the statement that i have to enter.
|
|
|
Re: oracle query [message #1072 is a reply to message #1071] |
Wed, 27 March 2002 06:08 |
INTROV
Messages: 20 Registered: February 2002
|
Junior Member |
|
|
Login in as admin.
The command to create user is
create user 'username' identified by 'secret password' default tablespace 'tablespace name' temporary_tablespace 'temporary tablespace name';
Then give connect and resource privileges to the user 'username'.
grant connect, resource to 'username'
Hope this helps
|
|
|