Skip to main content

Why does query

SELECT * FROM INVOICE

work without any special permissions but

SELECT * FROM IFSINFO.ALL_INVOICES_IAL (throws error - Aurena client)

require special permission on a Quick Report?

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?


Reply