撤销user1用户修改st表中的“姓名”字段的权限,应使用的SQL语句是(
)
A: REVOKE
UPDATE(姓名)
ON st TABLE FROM user1
B: REVOKE
UPDATE(姓名)
ON TABLE st FROM user1
C: REVOKE
MODIFY(姓名)
ON st TABLE FROM user1
D: REVOKE
MODIFY(姓名)
ON TABLE st FROM user1
)
A: REVOKE
UPDATE(姓名)
ON st TABLE FROM user1
B: REVOKE
UPDATE(姓名)
ON TABLE st FROM user1
C: REVOKE
MODIFY(姓名)
ON st TABLE FROM user1
D: REVOKE
MODIFY(姓名)
ON TABLE st FROM user1
举一反三
- 授予user1用户修改st表中的“姓名”字段的权限,应使用的SQL语句是(<br/>) A: GRANT<br/>UPDATE(姓名)<br/>ON st TABLE TO user1 B: GRANT<br/>UPDATE(姓名)<br/>ON TABLE st TO user1 C: GRANT<br/>MODIFY(姓名)<br/>ON st TABLE TO user1 D: GRANT<br/>MODIFY(姓名)<br/>ON TABLE st TO user1
- 将查询和修改Student表的权限授给用户U4的SQL语句是(<br/>)。 A: GRANT<br/>SELECT, UPDATE ON TABLE Student TO U4 B: REVOKE<br/>SELECT, UPDATE ON TABLE Student FROM U4 C: GRANT<br/>SELECT ON TABLE Student TO U4 D: REVOKE<br/>UPDATE ON TABLE Student FROM U4
- 下列SQL语句中,能够实现“收回用户user1对学生表中学号的修改权限”的是( )。 A: REVOKE UPDATE on student(sno) from ALL B: REVOKE UPDATE on student(sno) from user1 C: REVOKE UPDATE(sno) on student from user1 D: REVOKE UPDATE(sno) on student from PUBLIC
- 如果要删除user数据库中的user1表，可以使用下列哪个命令______ A: ALERT TABLE user1 B: DROP TABLE user1 C: DELETE TABLE user1 D: TRUNCATE TABLE user1
- Your network contains an Active Directory domain. A user named User1 takes a leave of absence for one year. You need to restrict access to the User1 user account while User1 is away. What should you do（） A: From the Default Domain Policy， modify the account lockout settings. B: From the Default Domain Controller Policy， modify the account lockout settings. C: From the properties of the user account， modify the Account options. D: From the properties of the user account， modify the Session settings.