Find User Privileges in the Database

Discussion created by Iris_Muttenthaler_7233 on Dec 20, 2016
Latest reply on Dec 20, 2016 by Christine_Chavez_6412
If you want to retrieve the information which privileges are assigned to a user in the database you can use the following SQL script:

SELECT OH_Client, OH_Name, USR_Privilege
from OH
inner join USR on OH_IDnr = USR_OH_Idnr
where OH_Client = 1
and OH_Deleteflag = 0
and OH_Name = 'MUI/SUP';

The column usr_privilege contains a decimal representation of the binary values for each privilege. You have to read it from right to left.

Let me explain for a Version 10 Automation Engine:

A user has only the privilege "ECC: Access to Predictive Analytics" assigned.
Value of usr_privilege column will be: 274877906944
Converted to binary: 100000000000000000000000000000000000000

A user with all privileges assigned will have a value of 549755679999
Converted to binary: 111111111111111111111011111010011111111

Here you can see that in V10 there are 4 positions which are not used: 9, 10, 12 and 18 (read from right to left)