1: SQL> CREATE ROLE mgrrole;
2: SQL> GRANT create user,select any table,connect,resource TO mgrrole;
3: SQL> GRANT select,update ON sh.sales TO mgrrole;
4: SQL> CREATE ROLE ceo IDENTIFIED BY boss;
5: SQL> GRANT mgrrole,drop any table,create any directory TO ceo;
6: SQL> GRANT ceo TO mgrrole;
Which statement is true about the above commands?
A. The commands execute successfully.
B. Command 6 produces an error because of circular role grant.
C. Command 5 produces an error because a role cannot be granted to another role.
D. Command 3 produces an error because the MGRROLE role already contains system privileges.
答案:(B)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1224983/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1224983/