oracle用户权限管理

--创建用户

--非配配额
--授权

--撤销

create user myuser identified by myuser 
default tablespace mytb
quota 50m on mytb;

 

grant select,update,delete,insert on scott.dept to myuser;

 

 grant create table to myuser;

 

revoke create table from myuser;