Error: 00942. 00000 - "table or view does not exist"

  • 23 September 2022
  • 2 replies

Userlevel 1
Badge +4

How can I add permissions for a user to can connects to see data in views by ‘SQL Developer’ tool (directly from the database Oracle) ?
Currently, the user can see tables, but views can't - by SQL Developer.


if I add IFSAPP perspective , then he connects but can’t see the data from view.

-off course this view have the data :



here is an example that user has connect to the table:


The issuse related with IFS 10.


Best answer by GGABJORNAR 23 September 2022, 15:21

View original

2 replies


Hi there, try this


  1. grant select on accounting_balance_auth to Scott;
  2. select * from accounting_balance_auth

If still not able to se the data, check that Scott has General Ledger access in Solution Manager under Authorize classes for the company

Userlevel 1
Badge +4

Yes, thank you!

Before, I did’t add this user to ‘users by authorization class’ in General Ledger 😅