User Authorizations Table

[#1]

Hello Experts,

I need to make a query on users authorization rights, when I go the authorizations screen via Administration>System Initialization>Authorizations>General Authorizations the system information view display SUB_NAME as a column of OPRM table used by the Authorizations window.

The problem is when I try to query the OPRM table SAP returns message "Invalid Object Name".

WHY?

If this is a normal case, is there another way to have a report on user module rights?

Thanks.

[Former Member]

OK, Thank you All.

[Former Member]

Thanks Gordon,

The first list exported shows the whole users that usually log on SAP but the second list exported shows Authorizations details for only one user (user selected on the screen), I have to repeat export procedure for each user in the Authorizations Screen.

Is it usually the same scenario ?or have I missed something?

Thank you.

Ben

[Former Member]

That is normal.

[Former Member]

Thanks to all but what is the alternate solution in this case? SAP should give a way to his customer for having an overview of all users rights and authorizations level on all Module in SBO for internal audit of control and risk. My report should be helpful for Audit purpose and I don't know how I can explain this if I use to give other report using the Query Manager.

It's so embarrassed. Please Help...

Thanks

Ben

[Former Member]

The link I posted previously is the only way you can do it. All other users go through that route already.

[jitin_chawla]

Hi Ben,

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.

Regards,

Jitin

SAP Business One Forum Team

Edited by: Jitin Chawla on Mar 6, 2009 11:13 PM

[Former Member]

Hi Jitin,

The note clear say Can Not be returned as a query result in a query. Where is you conclusion come from?

Thanks,

Gordon

[jitin_chawla]

Hi Gordon,

I am sorry about the typing Mistake.

Thanks for notifying.

Regards,

Jitin

SAP Business One Forum Team

[Former Member]

OPRM table is hidden from all users with good reason. There is no way to access this table by anyone.

[Former Member]

Gordon,

Thanks for your answer but this link doesn't contain information I need to query data in OPRM table.

[Former Member]

Please check this thread:

Thanks,

Gordon