Skip to Content

What are the tables associated with Authorizations Groups

I need to write a report regarding users is certain Authorization Groups. I cannot find which tables to report from. OUGR and UGR1 are two of the tables. I need the table that links the user to the Authorization Group.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Nov 20, 2017 at 01:52 PM

    Hi,

    You should use USR7, you can find the UserId and the GroupId

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 20, 2017 at 01:58 PM

    Hi

    you have to use the USR7 table: this table relates OUSR and OUGR.

    Kind regards

    Agustín Marcos Cividanes

    the user authorizations are saved in the OUSR table, but they are encrypted.

    Add comment
    10|10000 characters needed characters exceeded