+1I have deployed a new Quick Report in our environment and when users try to run this report from Aurena they get an error message stating that they need the DEFINE SQL system privilege. Do they truly need this permission? This was never required in IEE and I do not want to give users system privileges unless absolutely necessary.
Thanks
Best answer by knepiosko
Which update is it? Look at solution: 295830
Hi
As I know it was required in IFS10 version. Do You know which permission sets have You granted in IFS 10 version?
+1I have granted the quick report’s presentation object to the user’s permission set.
I don’t remember granting DEFINE SQL for users in the past, but I could be wrong. I would like some confirmation that this is actually required for running (not defining new) quick reports.
Maybe You granted DEFINE SQL indirectly by any default permission set without knowing this, eq: FND_ADMIN.
+1To be clear, this is my question:
For IFS Aurena, do end users require the system privilege DEFINE SQL to run SQL quick reports. (Not to define new ones)
I do not want to grant them this permission if it is not required.
+21Hi
We are using IFS Application 10 IEE and Aurena and we do not grant DEFINE SQL to users in order to execute quick reports. If you’ve created SQL directly in the quick report maybe consider moving the code into a custom VIEW and granting access to the view to public then changing the quick report to utilize the view.
Regards,
William Klotz
+1Which update is it? Look at solution: 295830
We’re on update 12. Looking at the bug reports now. Appears that UPD 14 should resolve this. Thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
