Skip to main content
Solved

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

  • September 23, 2022
  • 2 replies
  • 619 views

Forum|alt.badge.img+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.

Best answer by GGABJORNAR

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

2 replies

GGABJORNAR
Do Gooder (Customer)
Forum|alt.badge.img
  • Do Gooder (Customer)
  • 1 reply
  • Answer
  • September 23, 2022

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


Forum|alt.badge.img+6
  • Author
  • Sidekick (Partner)
  • 15 replies
  • September 23, 2022

Yes, thank you!

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