Oracle 创建表空间以及新建用户开设权限

create temporary tablespace yp_tmp_data tempfile 'C:\app\oracle\oradata\orcl\yp_tmp_data.dbf' size 1024m autoextend on next 128m;
create tablespace yp_data datafile 'C:\app\oracle\oradata\orcl\yp_data.dbf' size 1024m autoextend on next 128m;

create user yp identified by yp123456 default tablespace yp_data temporary tablespace yp_tmp_data;
grant connect,resource to yp;
grant dba to yp;