2014-07-07-3.sql

botang

select  * from dba_sys_privs sp where sp.grantee='U1';

select  * from dba_role_privs  rp where rp.grantee='U1';

select  * from dba_tab_privs  tp where tp.grantee='U1';

select  * from dba_col_privs  cp where cp.grantee='U1';

grant create table to u1;

select * from dba_ts_quotas;

alter user u1 quota 1M on users;

  alter user u1 quota 0 on users;

  
select * from dba_ts_quotas;




select  * from dba_sys_privs sp where sp.privilege ='UNLIMITED TABLESPACE';

select * from dba_roles r where r.role='RESOURCE';

select * from role_sys_privs  rsp where rsp.role='RESOURCE';

select  * from role_tab_privs  rtp where rtp.role='RESOURCE';

select  * from role_role_privs rrp where rrp.role='RESOURCE';




grant resource to u1;

  revoke unlimited tablespace from u1;