Skip to main content

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.

Hello,

Please refer to knowledge base article:

Best regards
Bartłomiej Pobocha


Reply