9.2.0.6
Oracle Solaris on Sparc (64-bit)
TEST user is unable to see some views on PRESENT schema even after the successful execution of the following Grants:
GRANT CREATE VIEW TO TEST;
GRANT CREATE SESSION TO TEST;
GRANT UNLIMITED TABLESPACE TO TEST;
grant SELECT on PRESENT.VW_AMZ_CONVENIO to TEST;
grant SELECT on PRESENT.VW_AMZ_BENEFICIARIOIF to TEST;
grant SELECT on PRESENT.VW_AMZ_REPRESENTANTE to TEST;
GRANT CONNECT TO TEST;
GRANT RESOURCE TO TEST;
When qyerying through TEST the following error occurs:
ORA-01031: insufficient privileges
The query in PRESENT occurs successfully, what am I missing?