Code Snippet

Just another Code Snippet site

[Oracle] Create new user/schema

Create simple tablespace :

create tablespace <tablespace_name>
datafile '<tablespace_file>'
size 256M
 autoextend off
 segment space management auto;

Create user/schema :

create user <user_name> identified by <user_password>
 default tablespace <tablespace_name>
 temporary tablespace <temp_tablespace_name>
 quota unlimited on <tablespace_name>
 quota unlimited on <tablespace_name_1>
 quota unlimited on <tablespace_name_2>;

Change grants :

grant ALTER ANY SEQUENCE,CONNECT,CREATE SESSION,RESOURCE to <user_name>;

,


One thought on “[Oracle] Create new user/schema

Leave a Reply to Olivier Cancel reply

Your email address will not be published. Required fields are marked *