+8As the topic says, I have an IAL, and would like to reference data in a QIS.
However, when I do this, and try to create the IAL, it says I have insufficient privileges.
I’m referencing the QIS as below… with IFSAPP.
SELECT tm.Week_Commencing from IFSAPP.QFACT_EDF_TIM_REG_DATA_IAS$ tm
Any thoughts?
+11
For testing your permission to the view, are you able to query that view in other ways?
+8Yes, the query I’m trying to run works fine in a quick report.
So, in my Quick Report, I am selecting from the QIS, which as we know exposes the IAL data.
However, when I try to put the code from the quick report into an IAL, it doesn’t allow me to. It says insufficient privileges, in relation to the select from the QIS.
+11Great, glad it works in a Quick Report with the same query as the same user.
I assume you have released other IAL’s before
I would see if &AO.. helps in this instance. (although I don’t think you would get this error)
The other thought I had was the Row Level Security on views, but that doesn’t seem to be included on QIS definitions. (You would also have missing data in the Quick Report, but not an error)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.