Which tables to read for collecting User authorisations

[dirk_konings]

Hi,

Which SAP tables do you have to read to get an overview on User Authorisation?

Which user could do what within SAP?

Regards

Dirk Konings

[marcus_sommer]

Perhaps this is helpful:

SAP Table Structure

SAP Tables Details.pdf

- Marcus

[dirk_konings]

Do you also know what the linking between these 'user' tables is?

D.

[Anonymous]

Hi Dirk,

Try table:RSECUSERAUTH which links Users to Authorisations and table: RSECVAL which links Authorisation to Authorisation assignments (for example Company Code, the data values that have been assigned to the BI authrosation objects).

The BI transaction for authorisation config is: RSECADMIN.

[marcus_sommer]

No, I don't - perhaps you find here more: http://community.qlik.com/search.jspa?q=SAP+table

- Marcus

[#6]

Hi Dirk,

according to Ganesh Paisa in the SAP community Network:

AGR_*  tables contains authorization data.

Some table are:

AGR_1250 : Authorization data for the activity group

AGR_USERS : Assignment of roles to users

AGR_SELECT  : Assignment of roles to Tcode

AGR_PROF : Profile name for role

AGR_DEFINE :Role definition

But could be a hard piece of work to figure out already the essential connections... Let me know if you achieve it.