PL/SQL 创建表空间及用户并赋予权限

--创建表空间 yuy
create tablespace yuy
       datafile '路径\yuy.dbf'
       size 36m
       autoextend on next 6m maxsize unlimited
       logging
       extent management local
       segment space management auto;
       
--创建用户 yuy，密码 yuy
create user yuy
       identified by yuy
       default tablespace yuy
       temporary tablespace TEMP
       profile DEFAULT;
grant dba to yuy with admin option;
grant unlimited tablespace to yuy with admin option;
--项目结束后以system用户角色登录，执行下面删除语句，删除用户及表空间引用，然后去路径下删除数据文件
drop user yuy cascade;
drop tablespace yuy;