将在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;
目前,国际上用于评估信息产品安全性的主要标准是________。
A. TCSEC
B. TCSEC/TDI
CC
D. ITSEC