创建Oracle用户

--创建临时表空间
create temporary tablespace tps_temp
tempfile 'D:/oracle/oradata/myJob/tps_temp01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;

 

--创建表空间

create tablespace tps
logging
datafile 'D:/oracle/oradata/myJob/tps01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;

 

--创建用户
create user jiy identified by jiy
default tablespace tps
temporary tablespace tps_temp;

 

--给用户授予权限
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO jiy