创建一个角色
create role role_test1;
grant create session to role_test1;
创建一个用户
create user user_test1 identified by test1;
赋予resource角色和role_test1角色
grant resource to user_test1;
grant role_test1 to user_test1;
此时user_test1拥有权限:
select * from dba_role_privs where grantee = 'USER_TEST1';
select * from dba_sys_privs where grantee = 'USER_TEST1';
得到
角色:resource和role_test1
权限:UNLIMITED TABLESPACE
得知赋予resource角色会自动给用户(而不是角色)赋予UNLIMITED TABLESPACE权限。
回收resource角色之后,也会自动回收UNLIMITED TABLESPACE权限
revoke resource from user_test1;
select * from dba_role_privs where grantee = 'USER_TEST1';
select * from dba_sys_privs where grantee = 'USER_TEST1';