authorization

[Former Member]

hi friends,

  we have 40 users license. every month we are checking the general authorization for every user. so i select every user and then import to excel sheet. i will go to do this process for every user and every month. so any query is there easily i need to take the autorization report for all user or otherwise kindly tell any other way

every month one day i will spent for this work

i will import the excel sheet like this way

[KennedyT21 · Accepted solution]

Hi Ramesh Kannan,

Query report for The Authorization Is not Possible ... SAP does not expose the authorization table as it has been locked..

So This Is not Possible, But why you need to check them monthly basics..

You can block the authorization rights for all expect the Super User..

Hope Helpful..

Regards

Kennedy

[Former Member · Accepted solution]

we should not block authorization . this is for review for every user  authorization that's why we will import the authorization status for every user. query is not possible ok. any other way is there

[KennedyT21 · Accepted solution]

Hi Ramesh kannan,

Create a Template for all user and update on monthly basics Using The DTW

You can find the template in

Data Transfer Workbench\Templates\Templates\Administration\System Initialization\Authorization\User Permission Tree

Hope This will make your work simple..

Regards

Kennedy

[Former Member · Accepted solution]

sorry wrongly i mentioned. not import i need to export all the users authorization friend . sorry it is my mistake. monthly monthly we export the general authorization for all user just for review . every user i will take the excel sheet. my requirement is i need to export all the user  authorization at a time.

all ready you told query is not possible? any other way is there

[KennedyT21 · Accepted solution]

No way Dear only export from the authorization  window is only possible way..

Regards

Kennedy

[Former Member]

Please follow this link. You can use the export part of this solution.

I've checked it and it's worked properly.

http://scn.sap.com/people/janos.nagy/blog/2010/01/25/exporting--importing-authorization-using-ms-exc...

[former_member209066]

Hi,

This Report possible only for SAP B1  8.81....

Thanks,

Nithi

[former_member184718]

Hi,

The authorization list is stored on the OPRM table.

However, the OPRM table cannot be accessed as it is not exposed by SAP. Also you cannot find this table in SQL.

865903 - What table are the authorisations saved in?

Version 3 Validity: 02.08.2005 - active Language English

Content:    Summary   |   Header Data   |   Validity

Symptom

What table are the authorisations are saved in?

Cause

Solution

The table OPRM stores authorization tree information which are static
values and will not be changed, so it is not stored in the Database, but hardcoded in the system.

Other terms

OPRM, Authorisation, sbo-adm-aut, sbo-adm, SAP Business One

Header Data

Released On	02.08.2005 21:38:07
Release Status	Released for Customer
Component	SBO-ADM-INI-AUT Authorizations
Other Components	SBO-ADM Administration
Priority	Recommendations/additional info
Category	FAQ

Validity

This document is not restricted to a product or product version

Thanks.

Hari