SAP B1 Authorization Tables

[#1]

Hello,

I am writing a query to show the authorization profiles of all users in a SBO database. I found three tables in the database tables reference file which are OUPT, UPT1, and USR3 but they are only showing authorization codes and not the name of the profile.

Are there any other tables to show the complete names of the user authorizations?

Thanks in advance for your help.

[Former Member · Accepted solution]

Hi Paul,

You cannot query the OPRM Table.

For further information you can refer to Note No.  1175770 which states as follows :

Number              1175770

Version               3 from 04.06.2008

Status                Released for Customer

Set on                04.06.2008

Language               EN

Master language     EN

Short text               User authorisations cannot be queried

Responsible          Kerstin Pauquet

Component           SBO-ADM-INI-AUT

                            Authorizations

________________________________________________________________________

Long text

Symptom

The user authorisations can not be returned as a query result in a query (e.g. for reports purposes).

Other terms

Authorisation, authorization, user, specific, allowed, full, read-only, no, query, manager, table, OPRM, OUSR, SAP Business One

Reason and Prerequisites

Consulting

Solution

The user authorisations of a SAP Business One database are only accessible to superusers within the application. The data is highly confidential & thus not exposed in the query manager/wizard or SQL Query analyser.

Thanks,

Srujal Patel