11-10-2010 6:28 AM
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.
11-10-2010 9:48 AM
Hello Giri,
Please check table USR04 once. Also, please checkt he tables starting with USR.
Hope that helps.
11-10-2010 10:47 AM
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
11-10-2010 3:01 PM
>
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
11-23-2010 4:51 PM
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
11-29-2010 4:53 PM
11-04-2013 12:12 PM
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