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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member182470
Active Contributor
0 Kudos

Check this table : AGR_USERS

http://scn.sap.com/thread/1329670

former_member195079
Participant
0 Kudos

Hello Suman,

Thank you for your answer,

Actually I need a table with relation of Relevant Authorization Infoobjetct against each query in the system.

Jose.

former_member182470
Active Contributor
0 Kudos

Check in RSDCHA table. http://scn.sap.com/thread/704769

Check in TOBJ table for authorization objects. You cannot get authorization objects with query details in single table. You need to get these info from multiple tables.

Try to correlate all the mentioned tables so far..

former_member202718
Active Contributor
0 Kudos

Hi Jose,

As far as i remember there are around 15 or soo Auth Objects which can be seen in RSECADMIN in F4 dropdown whencreating Auth Objects.

After this it will depend on what Auth Objects u have used in your Query out of those 14-15 Auth Objects.

The total Number of STD Auth Objects are Few.

Rgds

SVU

former_member182470
Active Contributor
0 Kudos

The required table given by me first, right? Do you think your assignment is correct?

former_member195079
Participant
0 Kudos

Hello Suman,

You are right. You give me the both table in the post attached.

Thank you.

Answers (1)

Answers (1)

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.