topic Re: table for Role & Authorization group in Application Development and Automation Discussions

table for Role & Authorization group

Former Member — Wed, 10 Nov 2010 06:28:28 GMT

Hi Gurus,

I am looking for a table or FM to get all roles for Authorization group.

I tried in SUIM tcode but could not able to find exact DB table for these.

Giri

P.S.: To Moderator:

My earlier thread was locked for the same question, I was searching in SDN and google from last 3 days and could not able to find enough information on it. AGR_USERS, TBRG, TACT are the tables i found. But still there is a link missed between Role & Authorization Group.

Re: table for Role & Authorization group

Former Member — Wed, 10 Nov 2010 09:48:56 GMT

Hello Giri,

Please check table USR04 once. Also, please checkt he tables starting with USR.

Hope that helps.

Re: table for Role & Authorization group

Former Member — Wed, 10 Nov 2010 10:47:01 GMT

Hi Giri,

You might try the tables --USR04 which gives the User master authorizations details

USR11 which gives User Master Texts for Profiles

UST12 which gives User master: Authorizations

USR12 which gives User master authorization values

USR13 which gives Short Texts for Authorization

You need to look into the tables for getting a relation between Authorization and role..

Hope it might help u..........and if not then sorry......

regards

rohit

Re: table for Role & Authorization group

ThomasZloch — Wed, 10 Nov 2010 15:01:35 GMT


P.S.: To Moderator:
My earlier thread was locked for the same question, I was searching in SDN and google from last 3 days and could not able to find enough information on it. AGR_USERS, TBRG, TACT are the tables i found. But still there is a link missed between Role & Authorization Group.

Alright, well your first attempt sounded like "do my work", you might admit that.

Which authorization group are you referring to, there is all different kinds, e.g. for tables, executable programs, G/L accounts, document types, many more...

Thomas

Re: table for Role & Authorization group

Former Member — Tue, 23 Nov 2010 16:51:46 GMT

Thomas,

My report have selection screen with Auth group and user.

If user provides Auth. Group then need to find all roles linked to auth group and users assigned to that role.

In my investigation, there is link between Auth. Group <--> Auth. object.

Also Auth. Object <--> Role.

but still there is a fine link missing between Auth Group <--> Role.

For Eg: Auth Object S_TABU_DIS will be associated to all Auth. Groups but assigned to only limited roles.

I tried to debug the SUIM transaction multiple times but couldn't find the tables to find the link and not able to find the FM's.

if anybody have any idea to find that link between Auth. Group & Role then it will be helpful....

Giri

Re: table for Role & Authorization group

Former Member — Mon, 29 Nov 2010 16:53:26 GMT

You can get BASIS team help on this

Re: table for Role & Authorization group

Former Member — Mon, 04 Nov 2013 12:12:06 GMT

Hi Giri,

Please try report:

RSUSR070

Then enter the field name under 'Selection by field name' e.g. for company code you can enter 'BUKRS' and field value any company code number. Then the system will find all the roles assigned to particular company code.

But you can set the break and in debugg you can see all the tables!.

Hope it will help you solve your problem.

Kind Regards

umer