Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

oracle view permission

Hello all,

I am now to qlik.

I used to use MS Access to connect to oracle database to retrieve data, now i am trying to use qlik to connect.

For the same user, same View, I am able to retrieve data using Access but not Qlik. it gives me error:

SQL##f - SqlState: S0002, ErrorCode: 942, ErrorMsg: [Oracle][ODBC][Ora]ORA-00942: table or view does not exist

sql select * from v_application

The user has been granted with SELECT and REFERENCES permission with the view v_application.

Any idea why?

Thanks.

Don

0 Replies