授予用户user1在SC表上查询所有数据和修改grade字段数据的权限，对应的SQL语句是________。
A. grantselect,updateontableSCtouser1;
B. grantselect,updateontableSC.gradetouser1;
C. grantselect,update(grade)ontableSCtouser1;
D. grantselectontableSC,update(grade)ontableSCtouser1;
查看答案
授予用户user1对S表和SC表的结构进行修改的权限，对应的SQL语句是________。
A. grant update ontableS,SCtouser1;
B. grant alter table ontableS,SCtouser1;
C. grant alter tableS, alter table SCtouser1;
D. grant update tableS, update table SCtouser1;
授予用户user2在S表和SC表上的所有数据操作权限，并具有给其他用户授权的权限，对应的SQL语句是________。
A. grant all privileges ontableS,SCtouser2 with grant option;
B. grant all privileges ontableS,SCtouser2 with admin option;
C. grant select,delete,update,insert ontableS,SCtouser2 with admin option;
D. grant all operations ontableS,SCtouser2 with grant option;
将在SC表上查询所有数据和修改所有数据的权限授予角色role_instructor，对应的SQL语句是________。
A. grant all select, all update ontableSCto role_instructor;
B. grantselect,update on all tableSCto role_instructor;
C. grantselect,update ontableSCto role_instructor;
D. grantselect,update ontableSCto role role_instructor;
将角色role_instructor指派给用户instructor1，并且允许该用户转授权限给其他角色，对应的SQL语句是________。
A. grant role role_instructor to user instructor1 with admin option;
B. grant role role_instructor to user instructor1 with grant option;
C. grant role_instructor to instructor1 with admin option;
D. grant role_instructor to instructor1 with grant option;
微信支付 
支付宝支付