数据库作业12：第四章：数据库安全性 习题

1
2
3
4
5
grant all privileges
on student,class
to U1
with grant option;

1
2
3
4
grant select,update(adress)
on student
to U2;

1
2
3
4
grant select
on class
to public;

1
2
3
4
5
create role R1;
grant select,update
on student
to R1;

1
2
3
4
grant R1
to U1
with grant option;

1
2
3
4
5
6
7
grant select
on worker
to WangMing
grant select
on apartment
to WangMing;

1
2
3
4
5
6
7
grant insert,delete
on worker
to Liyong
grant insert,delete
on apartment
to Liyong;

1
2
3
4
grant select
on worker
to public;

1
2
3
4
grant select,update(salary)
on worker
to Liuxing;

1
2
3
4
5
6
7
grant update
on worker
to Zhangxin
grant update
on apartment
to Zhangxin;

1
2
3
4
5
6
7
8
9
grant all privileges
on worker
to Zhouping
with grant option;
grant all privileges
on apartment
to Zhouping
with grant option;

1
2
3
4
5
6
7
8
9
create view sala
as
select(max(salary),min(salary),avg(salary))
from worker,apartment
where worker.ano=apartment.ano;
grant select
on sala
to Yanglan;

1
2
3
4
5
6
7
revoke select
on worker
from WangMing
revoke select
on apartment
from WangMing;

1
2
3
4
5
6
7
revoke insert,delete
on worker
from Liming
revoke insert,delete
on apartment
from Liming;

1
2
3
4
remove select on 职工
when user()=name
form all;

1
2
3
4
revoke select,update(salary)
on worker
from Liuxing;

1
2
3
4
5
6
7
revoke update
on worker
from Zhangxin
revoke update
on apartment
from Zhangxin;

1
2
3
4
5
6
7
8
9
revoke all privileges
on worker
from Zhouping
with grant option;
revoke all privileges
on apartment
from Zhouping
with grant option;

1
2
3
4
revoke select
on sala
from Yanglan;