Monday, August 16, 2010

Creating users for Oracle

Create User
SQL> CREATE SUBIN(USERNAME)IDENTIFIED BY SUBIN(PASSWORD);
User created.


Grant  permissions 
SQL> GRANT CONNECT, RESOURCE,DBA to SUBIN(USERNAME);
Grant succeeded.
 

Commit
SQL> COMMIT;

No comments:

Post a Comment