1、创建视图
CREATE VIEW view_name
SELECT column1,column2,…
FROM table_name
WHERE condition;
2、创建用户
create user user_name identified by password;
3、是否需要赋予创建视图的权限
grant create view to user_name ;
4、赋予视图查询权限
grant select on 库名.视图名 to user_name;
5、赋予连接的权限
grant connect to user_name;
6、登录新用户,验证视图是否可见