Grants for IALs on Quick Reports

Yes, you should give permission to IAL in New Permission Set > IAL Objects Tab.

Hi Bharath,

Thanks a lot for the reply. If you please share one or two more screenshots (for me the tab IAL Objects is not shown) …

/Haritha

Hi @waidyah 

all IALs you’ve created will be visible in the tab “IAL Object” on the screen “New Permission Set”.

You only need to acive the checkbox there.

If it isn’t visible then there was a proble during the creation of IAL.

Hi @waidyah ,

Something else I noticed,

You shouldn’t query form the IFSINFO.ALL_INVOICES_IAL  view instead you should query from the IFSINFO.ALL_INVOICES view (without _IAL).

so the Quick Report should be like,

SELECT * FROM IFSINFO.ALL_INVOICES

Best regards,

Ravi

That’s cool Ravi. But, why do we make the IAL for?