用Tran-SQL语句实现权限管理时,授予用户user1对Orders表的插入权限。下列授权语句正确的是 。
A.GRANT INSERT on Orders
B.GRANT INSERT to user1
C.GRANT INSERT to Orders on user1
D.GRANT INSERT on Orders to user1
A.GRANT INSERT on Orders
B.GRANT INSERT to user1
C.GRANT INSERT to Orders on user1
D.GRANT INSERT on Orders to user1
第1题
A.GRANT INSERT on Orders
B.GRANT INSERT to user1
C.GRANT INSERT to Orders on user1
D.GRANT INSERT on Orders to user1
第2题
A.GRANT SELECT on Orders from user1
B.REVOKE SELECT on Orders from user1
C.GRANT SELECT on Orders to user1
D.REVOKE SELECT on Orders to user1
第3题
A.GRANT SELECT on Orders from user1
B.REVOKE SELECT on Orders from user1
C.GRANT SELECT on Orders to user1
D.REVOKE SELECT on Orders to user1
第4题
A.GRANT 课程表 ON SELECT TO USER1 WITH GRANT OPTION
B.GRANT SELECT ON 课程表 TO USER1 WITH GRANT OPTION
C.GRANT USER1 ON 课程表 TO SELECT
D.GRANT SELECT ON USER1 TO 课程表
第5题
A.GRANT UPDATE(姓名),SELECT ON TABLE readers TO user1
B.GRANT UPDATE SELECT ON TABLE readers TO user1
C.GRANT UPDATE,SELECT ON TABLE readers TO user1;
D.其余选项全错
第7题
A.Ⅰ、Ⅱ 、Ⅲ
B.Ⅱ 、Ⅲ、Ⅰ
C.Ⅱ 、Ⅰ、Ⅲ
D.Ⅱ、Ⅰ
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!