myslq安全性练习

2、用户U1对两个表有select权限，撤销上述操作

CREATE ROLE U1;

GRANT SELECT

ON TABLE employee

TO U1;

GRANT SELECT

ON TABLE department

TO U1;

 

REVOKE SELECT

ON TABLE employee

FROM U1;

REVOKE SELECT

ON TABLE department

FROM U1;

运行截图

 

 

 

撤销截图

 

 

 

 

3.用户1对员工表有select权限，对工资（salary）字段有更新权限

撤销上述权限

GRANT SELECT,UPDATE(salary)

ON TABLE employee

TO U1;

 

REVOKE SELECT,UPDATE(salary)

ON TABLE employee

FROM U1;

运行截图

 

 

 

撤销截图

 

 

 

 

4、将所有的服务器权限授予到U1

GRANT ALL

ON *.*

TO U1

with grant option;

运行截图

 

 

 

5、授予用户U1两个表的所有权限，并可给其他用户授权

撤销上述权限

GRANT ALL

ON TABLE employee

TO U1

WITH GRANT OPTION;

GRANT ALL

ON TABLE department

TO U1

WITH GRANT OPTION;

 

REVOKE ALL

ON TABLE employee

FROM U1;

REVOKE ALL

ON TABLE department

FROM U1;

revoke grant option

on `上机实验_作业`.department

from U1;

revoke grant option

on `上机实验_作业`.employee

from U1;

运行截图

 

 

 

撤销截图

 

 

 

6、用户U2对两个表有insert和delete权限

撤销上述权限

CREATE ROLE U2;

GRANT INSERT,DELETE

ON TABLE employee

TO U2;

GRANT INSERT,DELETE

ON TABLE department

TO U2;

 

REVOKE INSERT,DELETE

ON TABLE employee

FROM U2;

REVOKE INSERT,DELETE

ON TABLE department

FROM U2;

运行截图：

 

 

 

 

 

撤销截图

 

 

 

总结

本次上机实验了解了安全性保护措施，能够熟练运用对用户权限的一些操作