Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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