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;
Very helpful post.
ReplyDelete