Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dirk_konings
Creator III
Creator III

Which tables to read for collecting User authorisations


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

5 Replies
marcus_sommer

Perhaps this is helpful:

SAP Table Structure

SAP Tables Details.pdf

- Marcus

dirk_konings
Creator III
Creator III
Author

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

D.

Anonymous
Not applicable

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

Not applicable

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.