项目场景:
创建用户和给用户授权
解决方案:
1、创建用户
至此用户才创建成功:
2、配置权限
把查询Student表权限授给用户test:
把对Student表和Course表的全部权限授予用户U2和U3
grant select on Student to test;
问题2:all privilege用不了?
grant all
on Student to test,U1;
grant all
on Course to test,U1;
grant select on SC to public;
grant select,update(sno) on SC to U1;
3、创建用户名
create login zff with password='***',DEFAULT_DATABASE=STU1;
create user U2 for login zff;
create user U3_none without login;
4、给相关用户配置权限
grant Insert on SC to U2 with grant option;
create user U6 without login;
GRANT INSERT
ON SC
TO U6
WITH GRANT OPTION;
create user U7 without login;
GRANT INSERT
ON SC
TO U7;
revoke update(sno) on Student from U4;
revoke select on SC from public;
revoke insert on SC from U5 cascade;
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)