Notifications
Clear all

3170711 - User Authorizations Cannot Be Queried

1 Posts
1 Users
0 Reactions
153 Views
admin
Posts: 366
Admin
Topic starter
(@admin)
Noble Member
Joined: 3 years ago

Symptom

User authorizations cannot be returned as a query result in a query manager/wizard or SQL Server Query analyzer.

Environment

SAP Business One

Resolution

  • The user authorizations of SAP Business One are only accessible to superusers within the application.
  • The superuser can print the data or export them to a file.
  • The OPRM table stores authorization tree information as static values which are modified. Therefore, the data is not stored in the database, but hardcoded in the system.
  • The data is highly confidential and therefore not exposed in the query manager/wizard or SQL Query analyzer.
  • The OPRM table is not an actual database table. You can only see a reference to OPRM once you log on as a superuser and you open the Authorizations window (Administration → System Initialization → Authorizations → General Authorizations) with system information enabled (View → System Information).
Reply
Share:
x  Powerful Protection for WordPress, from Shield Security
This Site Is Protected By
Shield Security