Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

User transactions via roles

Former Member
0 Kudos

Dear, I would like to find out in which tables I can find information concerning users having access to transactions via which roles.

I can do this per transaction via SUIM, but in which tables can I find this en masse?

Thanks, Peter

1 ACCEPTED SOLUTION

Former Member
0 Kudos

You can use SQVI to join AGR_USERS and AGR_1251. Search the forum for SQVI if you want to know about it

4 REPLIES 4

Former Member
0 Kudos

tables you should look at start with AGR_ and USR or UST

0 Kudos

Thanks a lot, I had done that but it doesn't show all roles. Is that possible? If I check via SUIM I get more roles than if I check via the AGR tables. Any idea why this is the case?

Former Member
0 Kudos

You can use SQVI to join AGR_USERS and AGR_1251. Search the forum for SQVI if you want to know about it

0 Kudos

Great, AGR_1251 is the trick. I know how to use SQVI. Case closed. Thanks.