单选题Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）A REVOKE ALL PRIVILEGES FROM USER tomB REVOKE ALL ON EMPLOYEE FROM USER tomC REVOKE EXECUTE ON EMPLOYEE FROM USER tomD REVOKE PRIVILEGES ON EMPLOYE

题目

单选题

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）

REVOKE ALL PRIVILEGES FROM USER tom

REVOKE ALL ON EMPLOYEE FROM USER tom

REVOKE EXECUTE ON EMPLOYEE FROM USER tom

REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

更多“单选题Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）A REVOKE ALL PRIVILEGES FROM USER tomB REVOKE ALL ON EMPLOYEE FROM USER tomC REVOKE EXECUTE ON EMPLOYEE FROM USER tomD REVOKE PRIVILEGES ON EMPLOYE”相关问题

第1题

Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?()A.REVOKE ALL PRIVILEGES FROM USER tomB.REVOKE ALL ON EMPLOYEE FROM USER tomC.REVOKE EXECUTE ON EMPLOYEE FROM USER tomD.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom

点击查看答案
第2题

实现“收回用户U4对学生表STUD中学号(XH)的修改权”这一功能的正确SQL语句是______。A．REVOKE UPDATE(XH)ON TABLE FROM U4；B．REVOKE UPDATE(XH)ON TABLE STUD FROM PUBLIC；C．REVOKE UPDATE(XH)ON TABLE STUD FROM U4；D．REVOKE ALL PRIVIL EGES ON TABLE FROM U4；

点击查看答案
第3题

收回用户li对表employee的查询权限，同时级联收旧li授予其他用户的该权限，SQL语句为：(52) select ON TABLE employee FROM li (53) ;（52）A．GRANTB．GIVEC．CALL BACKD．REVOKE

点击查看答案
第4题

下列SQL语句中，能够实现“收回用户ZHAO对学生表（STUD）中学号（XH）的修改权”这一功能的是（）A、REVOKE UPDATE(XH) ON TABLE FROM ZHAO B、REVOKE UPDATE(XH) ON TABLE FROM PUBLICC、REVOKE UPDATE(XH) ON STUD FROM ZHAO D、REVOKE UPDATE(XH) ON STUD FROM PUBLIC

点击查看答案
第5题

Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?（）A、REVOKE ADD, DELETE FROM USER tom ON TABLE tab1B、REVOKE ADD, DELETE ON TABLE tab1 FROM USER tomC、REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1D、REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom

点击查看答案
第6题

Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?（）A、REVOKE ACCESS ON DATABASE FROM USER bobB、REVOKE CONNECT ON DATABASE FROM USER tomC、REVOKE tom FROM ACCESS ON DATABASE BY USER bobD、REVOKE tom FROM CONNECT ON DATABASE BY USER bob

点击查看答案
第7题

Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?（）A、REVOKE SELECT FROM user2 ON TABLE org.tab1B、REVOKE SELECT ON TABLE org.tab1 FROM user2C、REVOKE READ ACCESS FROM user2 ON TABLE org.tab1D、REVOKE READ ACCESS ON TABLE org.tab1 FROM user2

点击查看答案

单选题Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）A REVOKE ALL PRIVILEGES FROM USER tomB REVOKE ALL ON EMPLOYEE FROM USER tomC REVOKE EXECUTE ON EMPLOYEE FROM USER tomD REVOKE PRIVILEGES ON EMPLOYE

题目

更多“单选题Which of the following statements is used to revoke all DML privileges on table EMPLOYEE from user TOM?（）A REVOKE ALL PRIVILEGES FROM USER tomB REVOKE ALL ON EMPLOYEE FROM USER tomC REVOKE EXECUTE ON EMPLOYEE FROM USER tomD REVOKE PRIVILEGES ON EMPLOYE”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容