数据库应用上机实验指导书
3、验证用户U2权限的SQL语句及执行结果； 验证U2查询权限
SELECT JNO FROM SPJ WHERE SNO='S5';
25
数据库应用上机实验指导书
验证U2插入权限 insert into spj
values('s3','p2','j2','200') select* from spj;
验证U2修改权限 UPDATE SPJ SET SNO='S3'
WHERE SNO='S5' AND JNO='J1' AND PNO='P3' SELECT* FROM SPJ;
26
数据库应用上机实验指导书
验证U2删除权限 DELETE FROM SPJ WHERE SNO='S2' SELECT* FROM SPJ;
27
数据库应用上机实验指导书
4、撤销用户U1、U2权限的SQL语句； 先在U1界面撤销U1对U2的授权 revoke all privileges
on spj from u2;
再在sa界面撤销sa对U1的授权，cascade是撤销所有U1的联级revoke all privileges on spj
from u1 cascade;
撤销权限后验证
SELECT JNO FROM SPJ WHERE SNO='S1';
28
