Choose two
Which two are true about the WITH GHANT OPTION clause?
A) The grantee can grant the object privilege to any user in the database,
with or without including this option
B) It can be used to pass on privileges to other users by the prantee
C) The grantee must have the GRANT ANY OBJECT PRIVILEGE system privilege to
use this option
D) It can be used for system and object privileges
E) It can be used when granting privilleges to roles.
F) It cannot be used to pass on privileges to PUBLIC by the grantee
Answer:BC
(解析:只有对象权限授权的时候才有这个选项;实验证明有这个选项的授权者可以把该对
象权限授权给所有人。)
F 答案错:SQL> grant select on scott.emp to public;
授权成功。
E 答案错:ORA-01926: 无法将 WITH GRANT OPTION GRANT 角色
C 答案对:
SQL> grant GRANT ANY OBJECT PRIVILEGE to hr;
授权成功。
SQL> conn hr/hr
已连接。
SQL> grant select on scott.emp to sh with grant option;