A、revoke select on hr.* from 'stu001'@'localhost'
B、revoke select on hr.students from 'stu001'@'%'
C、revoke select on hr.student from 'stu001'@'localhost'
D、revoke select on hr.students to 'stu001'@'localhost'
第1题
A.GRANT SELECT ON DB1(T1)TO u1
B.GRANT SELECT TO u1 ON DB1(T1)
C.GRANT SELECT TO u1 ON T1
D.GRANT SELECT ON T1 TO u1
第2题
A.GRANT SELECT ON DB1(T1) TO u1
B.GRANT SELECT TO u1 ON DB1(T1)
C.GRANT SELECT TO u1 ON T1
D.GRANT SELEVT ON T1 TO u1
第3题
B、grant select on emp to scott
C、grant on emp select to scott
D、grant scott on emp
第5题
A.REVOKE UPDATE (XH) ON TABLE FROM USER4;
B.REVOKE UPDATE (XH) ON TABLE STUD FROM PUBLIC ;
C.REVOKE UPDATE (XH) ON TABLE STUD FROM USER4;
D.REVOKE ALL PRIVILEGES ON TABLE STUD FROM USER4;
第6题
第7题
A.GRANT SELECT TO TABLE Students ON U1,U2 WITH PUBLIC B.GRANT SELECT ON TABLE Students TO U1,U2 WITH PUBLIC C.GRANT SELECT TO TABLE Students ON U1,U2 WITH GRANT OPTION D.GRANT SELECT ON TABLE Students TO U1,U2 WITH GRANT OPTION
第8题
EXEC sp_addrolemember“ (11) ”,“ (12) ”
(11)
第9题
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
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!