创建用户

Vivant

--创建表空间
create tablespace XXXX
datafile 'E:\ORADATA\XXXX.DBF' size 1024M
autoextend on next 10M maxsize 10240M;
--创建临时表空间
create temporary tablespace tempXXXX
tempfile 'E:\ORADATA\tempXXXX.dbf' size 50m
autoextend on next 10m maxsize 10240M;
--创建用户
create user XXXX identified by "PASSWORD"
--设置默认表空间
default tablespace XXXX
temporary tablespace tempXXXX;
--赋予用户权限
grant connect, resource to XXXX;
grant create synonym to XXXX;
grant unlimited tablespace to XXXX;
grant create database link to XXXX;
grant select,update,insert,delete on XXXX.XXXX to XXXX;