Solved

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

  • 23 September 2022
  • 2 replies
  • 298 views

Userlevel 1
Badge +6

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.

icon

Best answer by GGABJORNAR 23 September 2022, 15:21

View original

2 replies

Badge

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 +6

Yes, thank you!

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

Reply