Skip to Content
avatar image
Former Member

Query works in RSECADMIN but user getting No Authorization Error

Hello All,

I am facing a strange issue. The user is able to execute query in Analysis for Office and then enter values in variable selections screen but after entering variable values he is getting NO Authorization error. When I tried to execute same query with user's ID using RSECADMIN -> Analysis -> Execution As, The query works without any issue and shows the expected data. User has all required roles assigned to access the query.

What can be the issue here ?

Thanks in Advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Dec 13, 2017 at 06:19 PM

    Hello Rahul,

    Do you have any authorization variable of type exit ?

    If yes, check that no Sy-uname is used in the code...

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2017 at 07:06 AM

    Cause

    This can happen for below specific situation:

    1. A Customer Exit variable is used in the query definition or user's authorization definition. And:
    2. The Customer Exit coding uses system variable SY-UNAME in the logic to determine the returned value of the customer exit variable.

    This is because the value of SY-UNAME is always the logon user (A in this case), even if using "Execute as User B" function. The function "Execute as User" does not overwrite the value of SY-UNAME.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 31, 2017 at 05:53 AM

    Hi Rahul.

    1. You have to use the transaction code either RSECADMIN or RSUDO to check the missing authorization of user A in BW system.

    2. Refer the link

    https://wiki.scn.sap.com/wiki/display/BI/Authorization+in+SAP+NW+BI

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 31, 2017 at 02:58 AM

    Did u check su53?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 21, 2017 at 08:22 AM

    Thanks for your responses Frederic, Eugeniy and Loed.

    Basically one of our user A is getting 'No Authorization' Error while executing one of the BeX Query. We asked for reference user who has the access and able to display report. Compared both users in SUIM and found that both have same authorizations (Roles, Analysis Authorizations, S_RS_COMP/COMP1, S_RS_MPRO etc). reference user is able to access query without issue. but user A is getting no authorization error. He is having access to query it seems as he is able to enter values in variable screen. My assumption is, he is missing authorization to multiprovider data.

    What else can be the reason for such error ?

    Thank you in advance.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      If you have user A and user B who have same access, why don't you try to delete user A then recreate user A in reference to user B? Did you already try it?

      Regards,

      Loed

  • avatar image
    Former Member
    Jan 11 at 09:26 AM

    Hi all,

    Thank you very much for your responses.

    The reason was one of the customer exit used in user's authorization role was restricting users to specific country's data. I assigned the user with worldwide role and now the query is working for him. I am new to Authorization concepts so it took little longer to investigate the issue.

    Best Regards,

    Rahul Panchal

    Add comment
    10|10000 characters needed characters exceeded