问题:
scott把查询emp表权限给useradmin,useradmin把查询emp表权限给user2,
scott把给useradmin的查询emp表权限回收,问:user2是否还能查询emp表。
结果是不能查询了。
验证过程;
conn scott/tiger
grant select on emp to useradmin with grant option.
conn useradmin/p123
select * from scott.emp
可以查询
conn sys/orcl
create user user2 identified by p123
conn useradmin/p123
grant select on scott.emp to user2
#授予connect角色给user2
SQL> conn sys/orcl as sysdba
SQL> grant connect t