RE: Table to View Analysis authorizations of all users in BI

[sreekanth_sunkara]

Hi,

I want to pull a report in BI that shows all the users and their analysis authorizations. does anyone know how to view this report.

Thanks in Advance,

SS

[Former Member]

Hi,

You can refer all the RSEC* tables. Below are the tables that stores analysis authorizations information:

RSECHIE - Status of hierarchy authorizations

RSECTXT - Authorization text

RSECVAL - Authorization Value Status

RSECBIAU - Changes to Authorization (Last Changed By]

RSECUSERAUTH - BI Analysis authorization u2013 assignment to users

Change log tables:

RSECUSERAUTH_CL - Assignment of users

RSECHIE_CL - Change log of hierarchy authorizations

RSECTXT_CL - Authorization texts

RSECVAL_CL - Authorization Value Status

Hope this helps!!

Rgds,

Raghu

[sreekanth_sunkara]

thanks for your reply Raghu,

will it show the ones that are assigned through role assignments and not assigned manually. The reason i am asking is that when i tried to see table RSECUSERAUTH - BI Analysis authorization u2013 assignment to users. it says no table entries found. but when i go to RSECADMIN and type the user name i see AA on Role based tab.

Thanks in advance,

SS

Edited by: sun on Nov 10, 2010 4:34 PM

Edited by: sun on Nov 10, 2010 4:34 PM

[Former Member]

Hi Sun,

Role based AA are assigned using S_RS_AUTH. You can refer table UST12 u201CUser master: Authorizationsu201D. Enter u2018S_RS_AUTHu2019 in field OBJCT, u2018BIAUTHu2019 in FIELD, and* in VON.

You can replace * with any characterstic, if you are looking for a specific authorization.

Alternatively, you can use SUIM to quickly identify the S_RS_AUTH assigned roles/users.

Hope this helps!!

W.Rgds,

Raghu

[sreekanth_sunkara]

Thanks Raghu.

Thanks,

SS