Skip to Content
avatar image
Former Member

table for Role & Authorization group

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 10, 2010 at 09:48 AM

    Hello Giri,

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

    Hope that helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 10, 2010 at 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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 10, 2010 at 03: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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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