topic oracle view permission in QlikView https://community.qlik.com/t5/QlikView/oracle-view-permission/m-p/1340902#M833063 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I am now to qlik.</P><P></P><P>I used to use MS Access to connect to oracle database to retrieve data, now i am trying to use qlik to connect.</P><P></P><P>For the same user, same View, I am able to retrieve data using Access but not Qlik. it gives me error:</P><P></P><P>SQL##f - SqlState: S0002, ErrorCode: 942, ErrorMsg: [Oracle][ODBC][Ora]ORA-00942: table or view does not exist</P><P></P><P>sql select * from v_application</P><P></P><P>The user has been granted with SELECT and REFERENCES permission with the view v_application.</P><P></P><P>Any idea why?</P><P></P><P>Thanks.</P><P></P><P>Don</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z oracle view permission https://community.qlik.com/t5/QlikView/oracle-view-permission/m-p/1340902#M833063 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I am now to qlik.</P><P></P><P>I used to use MS Access to connect to oracle database to retrieve data, now i am trying to use qlik to connect.</P><P></P><P>For the same user, same View, I am able to retrieve data using Access but not Qlik. it gives me error:</P><P></P><P>SQL##f - SqlState: S0002, ErrorCode: 942, ErrorMsg: [Oracle][ODBC][Ora]ORA-00942: table or view does not exist</P><P></P><P>sql select * from v_application</P><P></P><P>The user has been granted with SELECT and REFERENCES permission with the view v_application.</P><P></P><P>Any idea why?</P><P></P><P>Thanks.</P><P></P><P>Don</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/oracle-view-permission/m-p/1340902#M833063 Anonymous 2020-11-25T16:16:04Z