反馈
问题:
<p>将Teachers表的查询权限授予用户U1和U2,并允许该用户将此权限授予其他用户。实现此功能的SQL语句如下<span style="color: #ff6347;">( )</span>。</p>
选项 A:
GRANT SELECT ON TABLE Teachers TO U1,U2 WITH PUBLIC
选项 B:
GRANT SELECT TO TABLE Teachers ON Ul, U2 WITH PUBLIC
选项 C:
GRANT SELECT ON TABLE Teachers TO Ul, U2 WITH GRANT OPTION;
选项 D:
GRANT SELECT TO TABLE Teachers ON Ul, U2 WITH GRANT OPTION;
答案:
C