1、查询该用户下永久表空间的路径
select name from v$datafile;
2、创建表空间,将表空间路径作为dbf文件路径
create tablespace YMGDGS
logging datafile'D:\APP\ADMINISTRATOR\ORADATA\ORCL\YMGDGS.DBF'
size 8192m autoextend on next 64m maxsize unlimited;
3、查看表空间是否创建成功
select * from dba_tablespaces
4、创建用户及密码
create user ymgdgs
identified by "ymgdgs"
default tablespace YMGDGS
profile DEFAULT
ACCOUNT UNLOCK;
5、查看用户是否成功创建
select * from all_users;
6、赋予权限
# 分别赋予权限
grant create session,create table to ymgdgs;
grant UNLIMITED TABLESPACE to ymgdgs;
grant select on V_$session to ymgdgs;
grant select on V_$sesstat to ymgdgs;
grant select on V_$statname to ymgdgs;
# 直接赋予dba权限
grant connect,resource,dba to ymgdgs;
7、查看是否成功赋予权限
select * from dba_users;
8、完成