“把查询sc表和更新sc表的grade列的权限授予用户user1”的正确SQL语句是( )。A.GRANT SELECT,UPDATE(grade)ON TABLE sc TO user1B.GRANT SELECT sc,UPDATE sc.grade TO user1C.GRANT SELECT,UPDATE ON TABLE sc.grade TO usedD.GRANT SELECT ON TABLE sc,UPDATE ON TABLE sc(grade) TO user1

题目

“把查询sc表和更新sc表的grade列的权限授予用户user1”的正确SQL语句是( )。

A.GRANT SELECT,UPDATE(grade)ON TABLE sc TO user1

B.GRANT SELECT sc,UPDATE sc.grade TO user1

C.GRANT SELECT,UPDATE ON TABLE sc.grade TO used

D.GRANT SELECT ON TABLE sc,UPDATE ON TABLE sc(grade) TO user1


相似考题