Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
dirk_konings
Contributor 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

Re: Which tables to read for collecting User authorisations

Perhaps this is helpful:

SAP Table Structure

SAP Tables Details.pdf

- Marcus

dirk_konings
Contributor III

Re: Which tables to read for collecting User authorisations

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

D.

c_rouse
New Contributor III

Re: Which tables to read for collecting User authorisations

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.

Re: Which tables to read for collecting User authorisations

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

- Marcus

Not applicable

Re: Which tables to read for collecting User authorisations

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.

Community Browser