| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
