create user A identified by Apassword,grant connect to Agrant select on test to A
grant select on 视图名字 to 用户名;