19.用户授权20.权限回收

19.用户授权

grant select
on student
to use1;

grant update
on student
to use1;

grant all privileges  --所有权限
on course 
to use2,use3;

grant select
on student
to use1
with grant option;  --可以权限传递

grant select 
on sc 
to public; --给所有人

20.权限回收

revoke select
on SC
from public;

revoke select
on course
from use2;

revoke select
on student
from use1;  --error 若要撤消或拒绝可授予的特权，请指定 CASCADE 选项。use1 给了use2查找权


revoke select
on student
from use1 CASCADE; --use1 use2 全都收回