--创建用户
--非配配额
--授权
--撤销
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;
--创建用户
--非配配额
--授权
--撤销
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;