Skip to main content

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.

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

Yes, thank you!

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

Reply


Terms & ConditionsCookie settings