1、创建表空间
create tablespace tablespace_name
datafile '/xxx/xxx/xxx/xxx/oradata/tablespace_name.dbf'
size 1g--表空间大小
autoextend on next 100M maxsize unlimited --按100m自动扩展,最大不限。
extent management local segment space management auto; --本地自动管理
2、创建用户
create user user_name identified by user_password default tablespace tablespace_name;
3、授权
grant connect,resource to user_name;
grant create any table to user_name;
grant create any view to user_name;
grant select any table to user_name;
alter user user_name quota unlimited on tablespace_name;