1. 首页
  2. IT资讯

级联授权中role中的权限不能单独的抽取出来授予别的用户

View the Exhibit to observe the privileges granted to the MGR_ROLE role. The SCOTT user has beenwww.supportcenter.cnhttp://www.supportcenter.cngranted 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 fromthem.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/450962/viewspace-1027273/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/194792.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code