REVOKE ACCESS ON DATABASE FROM USER bob
REVOKE CONNECT ON DATABASE FROM USER tom
REVOKE tom FROM ACCESS ON DATABASE BY USER bob
REVOKE tom FROM CONNECT ON DATABASE BY USER bob
第1题:
A.REVOKE DROP ON t1 FROM PUBLIC
B.REVOKE UPDATE ON t1 FROM PUBLIC
C.REVOKE DELETE ON t1 FROM PUBLIC
D.REVOKE CONTROL ON t1 FROM PUBLIC
第2题:
A.REVOKE ALL PRIVILEGES FROM USER tom
B.REVOKE ALL ON EMPLOYEE FROM USER tom
C.REVOKE EXECUTE ON EMPLOYEE FROM USER tom
D.REVOKE PRIVILEGES ON EMPLOYEE FROM USER tom
第3题:
实现“取消用户USER4对学生表STUD中学号(XH)的修改权限”这一功能的SQL语句是( )。
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;
第4题:
Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?()
第5题:
下列SQL语句中,能够实现“收回用户ZHAO对学生表(STUD)中学号(XH) 的修改权”这一功能的是()
第6题:
A.REVOKE ACCESS ON DATABASE FROM USER bob
B.REVOKE CONNECT ON DATABASE FROM USER tom
C.REVOKE tom FROM ACCESS ON DATABASE BY USER bob
D.REVOKE tom FROM CONNECT ON DATABASE BY USER bob
第7题:
Users of your web application have requested that they should be able to set the duration of their sessions.So for example, one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes; another user might want to stay connected for a whole day. Furthermore, youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will accomplish this goal?()
第8题:
The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()
A. Alice only
B. Alice and Reena
C. Alice, Reena, and Timber
D. Sue, Alice, Reena, and Timber
第9题:
Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?()
第10题:
Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?()