cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Custom Report - DPA user role report

In DPA there is an option to set custom privileges and roles to a DPA user. This is discussed here https://documentation.solarwinds.com/en/Success_Center/dpa/Content/DPA-DPA_Roles_Privileges.htm

What is some cumbersome in DPA however is getting an audit of these custom permissions for a large list of users. In the options menu under User administration the view only shows the users or groups and then a role of "custom" to see what each user or group has you have to click into that user or group. 

Example in the below I can't see what Limit_test1 has for rights until I click that user. 

user_admin.png

user_admin2.png

The following query can be run on the repository to see these roles for the users in DPA should you need this info in a list format. 

Select
d.NAME [Server_name]
,d.CONN_HOST
,u.NAME [user_name]
,cug.NAME [group_name]
,cug.ROLE
,pd.DESCR
,pd.READONLYPRIV
from CONUSER u
inner join CONUSERPRIVS up
on u.ID = up.USERID
left join CONUSERGROUP cug
on cug.ID = up.PRIVID
inner join CONPRIVDEF pd
on pd.ID = up.PRIVID
Inner join cond d
on up.TARGETID = d.ID

Comments

Useful thankyou.

Version history
Revision #:
1 of 1
Last update:
‎08-03-2020 04:53 PM
Updated by: