数据库第四章作业三
4.11
代码
CREATE ROLE r1 PASSWORD "r1r1r1r1!";
截图
代码
GRANT SELECT,UPDATE,INSERT
ON TABLE student
TO r1;
截图
代码
GRANT r1
TO u1;
截图
代码
REVOKE r1
FROM u1;
截图
4.12
代码
GRANT DELETE
ON TABLE student
TO ri;
截图
4.13
代码
REVOKE SELECT
ON TABLE student
FROM r1;
