级联授权中role中的权限不能单独的抽取出来授予别的用户
View the Exhibit to observe the privileges granted to the MGR_ROLE role. The SCOTT user has been
www.supportcenter.cn
http://www.supportcenter.cn
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?[@more@]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.
www.supportcenter.cn
http://www.supportcenter.cn
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?[@more@]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.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/450962/viewspace-1027273/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
oracle 删除记录的rowid的规律
下一篇：
audit
请登录后发表评论
登录
全部评论
