创建用户

create user gzsly_quality identified by "gzsly_quality";

授权

grant create session to gzsly_quality;
grant create table to  gzsly_quality;
grant create view to  gzsly_quality;

创建表空间

create tablespace gzsly_quality 
datafile '/oracel/tablespace/gzsly_quality.dbf' 
size 200M 
autoextend on next 5M maxsize 3000M;

授权用户表空间

alter user gzsly_quality quota unlimited on gzsly_quality;

修改用户缺省表空间

Alter user gzsly_quality default tablespace gzsly_quality;

查看用户表空间

select username,default_tablespace from dba_users;

查询所有用户

select * from all_users; 

删除用户

drop user gzsly_quality CASCADE

删除表空间

drop tablespace gzsly_quality including contents and datafiles