full authorization SQL query

[nextcom]

Hello,

I have more then 100 users - I can not execute the authorization report through excel .

I am looking for SQL query which show me the permission's per user similar for the standard report which is export from excel.

it's very wired that there is no query like that - I did'nt find it anywhere .

Fields for retrieving the report before generating the report that will allow retrieval by module type - such as sales/finances/all, etc., as well as retrieval based by the employee's department - that would be great.

if there is no such report - it would be great if someone would write this query and publish it for the usefull for everyone

[SonTran]

Hi,

We cannot query authorization information.

You can refer SAP Note 3170711 - User Authorizations Cannot Be Queried

Hope this helps,

Son Tran

[Johan_H]

Hi,

With that many users, you should manage authorizations through user groups:

1. Create and/or edit groups: Administration > Setup > General > User Groups

2. Assign users to group(s): Administration > Setup > General > Users > User Groups

3. Determine authorizations for the group(s): Administration > System Initialization > Authorizations > General Authorizations > Groups

For the report you now only have to copy the group authorizations to Excel.

Regards,

Johan

[nextcom]

I asked for sql query for autorizatiins/permission....

[Johan_H]

Like sontran said, this information is not accessible by query.

With the method above, you can right click the form, and use 'Copy table' to get the info into Excel.