Hi

As I know it was required in IFS10 version. Do You know which permission sets have You granted in IFS 10 version?

I 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.

To 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.

Please do this->

Grant select on your_view_name TO public ;

commit;

Hi @SAARBISHOP ,

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

Which 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!