Skip to Content

Queries started executing with 02 level access intead of 03

Hi,

We have multiple queries that were running fine and then all of a sudden, the users started getting no data found. When someone with eleveated access runs the queries, we get data. A security trace shows that the queries are now using S_USER_AGR RC=4 & ACTVT=02. Security tell me that the execution should be ACTVT=03 but the cannot find out why all of a sudden it is trying it as ACTVT=02.

Where can we look to see why the queries are trying to execute with update type authority all of a sudden instead of just their normal read authority.

Note: The queryies have not changed. There are multiple queries involved and multiple info providers are involved.

Any help you can provide will be appreciated.

Thanks!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Dec 15, 2011 at 08:47 PM

    A new BEx Global workbook had been published causing this unexpected result. The change was backed out.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.