Solved

IFS 9 Database read only user for

  • 15 November 2022
  • 29 replies
  • 227 views


Show first post

29 replies

Userlevel 7
Badge +22

Can you post a screenshot of the accounting table you mean?

Badge +3

bascially, i need a database read only user to access all the data for reporting purposes,

i have tried granting selection to all objects but it's not working.

 

 

Userlevel 7
Badge +22

Hi @yasirB 

if the user can see the screen but can’t access to data then check the accounting rules and general ledger in the user:

 

 

 

Userlevel 5
Badge +12

Did you state is correctly that you’re querying a TABLE?

you can not directly grant access to tables from IFS applications. instead it will be always the VIEW. I have seen RMB > grant all, Grant query all sometimes misses couple / more objects hence always good to drill down more specifically through the components tree 

Reply