136. View the Exhibit to observe the privileges granted to the MGR_ROLE role.
The SCOTT user has been granted the CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to the SCOTT user by using this command:
SQL> GRANT MGR_ROLE TO SCOTT WITH ADMIN OPTION;
Which statement is true about the SCOTT user after he is granted this role?
A) The SCOTT user can grant the MGR_ROLE role and the privileges in it to other users.
B) The SCOTT user can grant the privileges in the MGR_ROLE role to other users but not with ADMIN_OPTION.
C) The SCOTT user can grant only the MGR_ROLE role to other users but not the privileges in it.
D) The SCOTT user can grant the privileges in the MGR_ROLE role to other users but cannot revoke privileges from them.
答案：C
ADMIN OPTION当有这个字段时，表明可以把该权限赋予另外一个人
获得该角色的用户只对该角色有管理的权限,不能对该角色所拥有的对象权限或系统权限进行操作.(需实验)
另:授予他人的对象权限在被授予者向第三人授予该权限时，最初授权者无法取消第三人的对象权限。但是如果最初授予的是系统权限，则最初授权人可以取消第三人的系统权限。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718644/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
