1.create user A identified by password,创建用户
create user USER_JWFZ identified by JWFZ2017;
2.grant connect to A --授予connect权限
grant connect to USER_JWFZ ;
3.grant select on test to A --给指定用户的表或者视图授予select(只读)权限,其中test是表名或者视图名
grant select on USER_AHUTJWFZ.V_AB_ATTENDANCE_ATTRECORD to USER_JWFZ;