A: GRANT INSERT to orders on user1
B: GRANT INSERT to user1 on orders
C: GRANT INSERT on orders to user1
D: GRANT INSERT on orders
举一反三
- 用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
- 在SQL Server中实现权限管理时,授予用户user1对Orders表的插入权限。下列授权语句正确的是 A: GRANT INSERT to Orders on user1 B: GRANT INSERT to user1 C: GRANT INSERT on Orders D: GRANT INSERT on Orders to user1
- 用Tran-SQL语句实现权限管理时,收回用户user1对Orders表的查询权限。下列收回权限语句正确的是: 。 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
- 使用GRANT语句创建用户名为user1、密码为123,并授予该用户对chapter08.student表有查询权限。 下面选项中,能实现上述功能的语句是 A: GRANT SELECT ON chapter08.student FOR 'user1'@'localhost' IDENTIFIED BY '123'; B: GRANT USER SELECT ON chapter08.student TO 'user1'@'localhost' IDENTIFIED BY '123'; C: GRANT USER SELECT ON chapter08.student 'user1'@'localhost' IDENTIFIED BY '123'; D: GRANT SELECT ON chapter08.student TO 'user1'@'localhost' IDENTIFIED BY '123';
- 用Tran-SQL语句实现权限管理时,授予用户user1对Orders表的插入权限。下列授权语句正确的是 。
内容
- 0
设有如下语句: GRANT SELECT,INSERT ON*TO'User1'@'loaclhost' IDENTIFIED BY 'userpwd' WITH GRANT OPTION; 执行以上语句,以下叙述中错误的是()。 A: User1被赋予对所有数据库、所有表的SELECT,INSERT权限 B: User1的口令是userpwd C: User1可以把自己所拥有的权限转移给其他用户 D: 若User1不存在,则系统先建立用户,再授权
- 1
用Tran-SQL语句实现权限管理时,收回用户user1对Orders表的查询权限。下列收回权限语句正确的是: 。
- 2
授予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
- 3
【单选题】把对Student表的全部操作权授予用户User1和User2的语句是(1.0分) A. GRANT All ON Student TO User1, User2; B. GRANT Student ON All TO User1, User2; C. GRANT All TO Student ON User1, User2; D. GRANT All TO User1, User2 ON Student;
- 4
“把查询SC表和更新SC表的grade列的权限授予用户user”的正确SQL语句是( )。 A: GRANT SELECT sc.UPDATE sc.grade TO user B: GRANT SELECT,UPDATE(grade)ON TABLE sc TO user C: GRANT SELECT,UPDATE ON TABLE sc.grade TO user D: GRANT SELECT ON TABLE sc,UPDATE ON TABLE sc(grade)TO user