Hi,
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.
But you can export the authorization lists.
Below steps are from SAP Note:1086776
When Exporting the Authorisation the list of user name will be imported first and then the list of authorisation second.
In order to have all the authorisations you will need to expand all the menu and sub menu.
Adminitstration -> system initialisation -> System initialisation -> Authorisations -> General authorisations
1. In the Authorisations window
2. Click on expand
3. With the Authorisations' window active click on Excel icon or go to File -> Export -> Export to MS Excel
4. In the first 'Save as' window opening
5. Name your 'User' file and select the relevant folder
6. At the system message popping :'Do you want to export currency symbols ?'
7. Click independently on 'Yes' or 'No'.
8. A security warning message will appear.
9. Click on 'Enable Macros'
10. A second 'Save as' window is opened.
11. Name your 'Authorisations list' file differently.
12. Execute again step 6 to 9
The two files will then open. One with the list of users one with the list of authorisations
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.