6.1
grant all privileges
on 学生
to U1
with grant option;
grant all privileges
on 班级
to U1
with grant option;
6.2
grant select,update(家庭住址)
on 学生表
to U2;
6.3
grant select
on 班级
to public;
6.4
create role R1;
grant select,update
6.1
grant all privileges
on 学生
to U1
with grant option;
grant all privileges
on 班级
to U1
with grant option;
6.2
grant select,update(家庭住址)
on 学生表
to U2;
6.3
grant select
on 班级
to public;
6.4
create role R1;
grant select,update