Skip to Content
avatar image
Former Member

table name to find out roles assigned to USER !!

Hi BW Gurus,

i want to find out all the roles assigned to users , i check in tables USR01, USR02 , USR21, and ADRP ...... i got first name , last name , account number . BUT I NEED ROLES . can anyone kindly help me ,since otherwise i have to copy paste all manaully which takes more time...

100% points are assingned

SHERWIN

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 08, 2008 at 09:22 AM

    Hello,

    Check in this tables:

    AGR_USERS - Assignment of roles to users

    AGR_USERT - Assignment of roles to users

    AGR_PROF - Profile name for role

    AGR_AGRS - Roles in composite roles

    Assign points if this helps

    Regards,

    Jorge Diogo

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 08, 2008 at 09:15 AM

    Hi

    Try it out in SUIM

    User Information System -> Roles -> By User Assignment.

    Hope it helps you.

    -SRS

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 08, 2008 at 09:25 AM

    Hi

    Use this function module

    NAVIGATION_SELECT_USER_OF_AGRS

    Enter the technical name of the Role

    Execute.

    It will give you the users in that role.

    Regards

    M.A

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 08, 2008 at 09:01 AM

    Hi

    Go to SU01 or SU01D and enter the user name and display , Go to roles TAB and you can view the roles assigned to the user.

    Regards

    M.A

    Add comment
    10|10000 characters needed characters exceeded