Question

permission set query

  • 25 November 2022
  • 1 reply
  • 147 views

Badge +1
  • Do Gooder
  • 3 replies

Hello,

i am looking in which table i can find the information of full granted or juste in read only for some screen ( frm or tbw), 

in IFS EE we can see this information but i need to make a query ( like quick report).

if it’s possible ti query that in database thank you for help.

i made this query but i cant found the information of read only or read/write, i dont know what mean the column ALLOW_READ_ONLY_DB ?

select t.po_id,t.description,a.allow_read_only_db,b.role
from ifsapp.pres_object_description t, ifsapp.pres_object a,ifsapp.pres_object_grant b
where t.po_id=a.po_id
and a.po_id=b.po_id

Regards.


1 reply

Userlevel 3
Badge +8

Hello,

Please refer to knowledge base article:

Best regards
Bartłomiej Pobocha

Reply