授予用户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;
撤销用户user1在S表和SC表上插入数据和删除数据的权限，对应的SQL语句是________。
A. revoke insert,deleteontableS,SC to user1;
B. revoke insert,deleteontableS,SC from user1;
C. revoke insertanddeleteontableS,SCtouser1;
D. revoke insert on table S,deleteontable SC from user1;
级联撤销user1用户在SC表上修改grade字段数据的权限，对应的SQL语句是________。
A. revoke update ontableSC from user1;
B. revoke update(grade)ontableSC from user1;
C. revoke update(grade)ontableSC from user1 restrict;
D. revoke update(grade)ontableSC from user1 cascade;
微信支付 
支付宝支付