1.新建用户
create user usercode identified by password;
2.新建表空间
create tablespace SPACE datafile ‘F:\SPACE.DBF’
size 200m
autoextend on
next 32m maxsize 2048m
extent management local;
3.新建临时表空间
create temporary tablespace TEMP_SPACE tempfile ‘F:\TEMP_SPACE .dbf’ size 50M autoextend ON next 10M maxsize 100M;
4.给用户默认表空间和临时表空间
alter user usercode default tablespace SPACE temporary tablespace TEMP_SPACE ;
5.给用户赋予数据库权限
grant create session,create table,create view,create sequence,unlimited tablespace to usercode;