create tablespace test datafile 'e:/test.dbf' size 50M
default storage (initial 500K
Next 500K
minextents 1
maxextents unlimited
pctincrease 0);//创建表空间
select * from dba_tablespaces;//查看所有的表空间
create user test identified by test default tablespace test;//创建用户
select * from dba_users;//查看所有的用户
select * from dba_sys_privs p where p.grantee='TEST';//查看所有用户的系统权限
grant CREATE TABLE to test with admin option;//给用户授系统权限,指定允许向其他用户授权
revoke CREATE TABLE from test;//取消授权
grant resource,connect,dba to test;
drop tablespace test including contents and datafiles;//删除表空间
drop user test cascade; //删除用户