给一个用户创建查询别人的视图的语句

CREATE USER ZF_QUERY IDENTIFIED BY ***;

GRANT CONNECT TO ZF_QUERY;

ALTER USER ZF_QUERY DEFAULT ROLE NONE;

GRANT CREATE SESSION TO ZF_QUERY;

GRANT CREATE ANY SYNONYM TO ZF_QUERY;

CREATE SYNONYM ZF_QUERY.view_hzqyhznr_qryb FOR view_hzqyhznr_qryb;

GRANT SELECT ON view_hzqyhznr_qryb TO ZF_QUERY;