Skip to Content
avatar image
Former Member

BI authorization - S_RS_COMP, S_RS_COMP1

Hi,

Do you have anybody experience with authorization for BI object (queries) like this:

Analyst, who can change queries, which was created by him and can execute all queries.

How to set authorization objects S_RS_COMP and S_RS_COMP1?

I have problem when I set S_RS_COMP1 fot RSZOWNER - $USER, than I see only queries that I created but I can ´t execute another queries, but when I add another role only for executing (without change activitiy) than I can change all queries.

thanks for advice.

Petr

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 21, 2011 at 01:50 PM

    Hi

    This is because Role 1 has Display/Execute authorizations and Role 2 has all authorizations. Role 2 is overwriting (just like read access and write access).

    If you want the user to restrict the queries , ask the user to create queries with naming convention starting from C(can do Save as) and create a new role and restrict the access Change /Display and execute but restrict the Name of reporting component to C., which provides access to his queries for Change/Display and Execute. Also assign him Role 1 which only has display and Execute access, providing access for exectuing all the queries.

    Hope this helps,

    Aparna Duvvuri

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Miro,

      maybe I find the problem. S_RS_COMP1 is not direct under the node S_RS_COMP (2) in the tree, so maybe it s problem I don t really know. Is it possible to hang up S_RS_COMP1 direct under S_RS_COMP (2)? No I have it in the independent node ind Business information Warehouse node.

      thanks

      Petr