1、创建用户
create user '用户名'@'%' identified by '密码';
create user 'test'@'%' identified by '123';
2、赋予视图权限
GRANT SELECT ,show view on 视图名 to '用户名'@'%';
GRANT SELECT ,show view on test_view to 'test'@'%';
如果觉得《MySQL创建用户并赋予某个视图权限》对你有帮助,请点赞、收藏,并留下你的观点哦!
时间:2023-09-05 21:41:50
create user '用户名'@'%' identified by '密码';
create user 'test'@'%' identified by '123';
GRANT SELECT ,show view on 视图名 to '用户名'@'%';
GRANT SELECT ,show view on test_view to 'test'@'%';
如果觉得《MySQL创建用户并赋予某个视图权限》对你有帮助,请点赞、收藏,并留下你的观点哦!