oracle创建表空间,用户,授予权限操作

//创建表空间
create tablespace GPOWERGIS datafile 'H:\app\fucs\oradata\orcl\GPOWERGIS.dbf' size 100M;
//创建用户和密码赋值到表空间
create user GPOWERGIS identified by GPOWERGIS default tablespace GPOWERGIS;
//授予权限
grant connect,resource to GPOWERGIS;
grant dba to GPOWERGIS;