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?
Grants for IALs on Quick Reports
Userlevel 1
+7
Yes, you should give permission to IAL in New Permission Set > IAL Objects Tab.
Userlevel 1
+7
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
Userlevel 7
+22
Hi
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.
Userlevel 2
+4
Hi
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
Userlevel 1
+7
That’s cool Ravi. But, why do we make the IAL for?
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.