Google IT Solutions: ORACLE user create

Thursday, 29 May 2014

ORACLE user create

How to create user in oracle;

CREATE USER TEST IDENTIFIED BY TEST;
DEFAULT TABLESPACE USERS;
TEMPORARY TABLESPACE TEMP;
PROFILE DEFAULT;
ACCOUNT UNLOCK;

How to grant access to user;
-----Role for USER----
GRANT DBA TO TEST;
ALTER USER TEST DEFAULT ROLE ALL;
-------System Privilege for USER------
GRANT UNLIMITED TABLESPACE TO TEST;

1 comment: