“把查询sc表和更新sc表的grade列的权限受予用户user1”的正确SQL语句是()。A、GRANT SELECT,UPDATE(grade)ON TABLE sc TOuser1B、GRANT SELECT sc,UPDATE sc,grade TO user1C、GRANT SELECT,UPDATE ON TABLE sc.grade TO user1D、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 TOuser1
B、GRANT SELECT sc,UPDATE sc,grade TO user1
C、GRANT SELECT,UPDATE ON TABLE sc.grade TO user1
D、GRANT SELECT ON TABLE sc,UPDATE ON TABLE sc(grade)TO user1