Skip to Content

Not authorized to delete query view

We have (we thought) given BI users the ability to delete their own queries and query views, under specific conditions. For this example, assume the query VIEW is named Y_QUERY_VIEW, and it is based on QUERY Z_QUERY.

For authorization object S_RS_COMP, the user has the following authorizations, among the other fields:

ACTVT = *

RSZCOMPID = Y*

RSZCOMPTP = QVW, REP

For S_RS_COMP1

ACTVT = 02, 03, 06, 16, 22

RSZCOMPID = Y*

RSZCOMPTP = QVW, REP

RSZOWNER = $USER

Now I've seen in other posts where there may or may not be an issue with restricting this access to the owner of the query view, but that is not my problem.

When the user attempts to delete the query view, Y_QUERY_VIEW, I see in the ST01 trace that they are failing the following authorization check for S_RS_COMP:

ACTVT=06

RSZCOMPID=Z_QUERY

RSZCOMPTP=REP

Why would BI check the user's authorization to delete the actual query that the query view is built on? And how do we get around this to allow them to delete (preferably) *their own* query views?

Thanks for the help.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 04, 2012 at 12:30 PM

    Hi,

    Actually you should be able to delete the query view through the given authorizations but not sure why you are getting error?

    [http://help.sap.com/saphelp_nw04s/helpdata/en/46/0294bc82f37041e10000000a155369/content.htm]

    Try deleting the view through RSZDELETE transaction.

    Regards,

    Durgesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 24, 2012 at 12:03 PM

    Same problem here. Is there any solution?

    When recording a trace the object RSZCOMPID displays the name of the query instead of the query view. I don't want to give users authorizations to delete queries, but only views.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 25, 2012 at 10:35 AM

    Dear Mark,

    Could you please implement the Note 1727956 and retest.

    Please note that there are some manual steps to be followed. please implement them as well.

    Regards,

    Arvind

    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.