cancel
Showing results for 
Search instead for 
Did you mean: 

Authorization Relevant Infoobjects for Queries

former_member195079
Participant
0 Kudos

Hello Gurús,

We are setting the authorizations objects for all 2500 BEx Querys of my Company.

I know the RSECADMIN option to see which are the authorization objects for specificly query.

Is there a way, like table or report to check all the "Authorization Relevant Infoobject" for all the querys I have?

For example:

QUERY TECHNICAL NAMEAUTHORIZATION RELEVANT INFOOBJECT
0SD_C03_Q0010COSTCENTER
0SD_C03_Q0010SALESORG
0SD_C03_Q0010REGION
0SD_C03_Q0020COSTCENTER
0SD_C01_Q0010SALES_OFF

I need a report like that. For each query see all the relevant authorization infoobjects.

Thank you for your help.

Jose.

View Entire Topic
former_member213275
Contributor
0 Kudos

Hi Jose,

Check table "RSDCHA"

OBJVERS     = 'A'

AUTHRELFL = 'X'  --> if set then it gives results of authorization objects for Reporting

MASTAUTHFL = 'X'--> If this indicator is set, maintenance of the master data / texts for

this characteristic can be protected for the single records by means of

authorizations.

Hope this helps.

Srikanth.

former_member195079
Participant
0 Kudos

Hello Srikanth,

Thank you for your response, that fields was useful to get my solution. I combine the table RSDCHA with the table RSDCUBEIOBJ using the field AUTHRELF.

I get all the infocubes that has Relevant Authorization Infoobject.

Thank you for your help.