本文揭示了WITH GRANT OPTION选项在数据库权限授予中的关键作用，包括对象权限的转移、限制条件及常见误解。通过实例说明，它允许用户将权限赋予他人，但需注意并非所有权限都适用，且不能随意授予PUBLIC。
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;
188
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
