Skip to main content
Solved

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

  • September 23, 2022
  • 2 replies
  • 528 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

View original
Did this topic help you find an answer to your question?

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 😅


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings