• RE: User permissions report

    Unfortunately until now, this feature is not available in DocuWare, anyway you can generate a report to show 'User Group/Role Membership' using SQL query as follows:
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    SELECT * FROM 
     (
     SELECT dbo.dwuser.name as UserName,dbo.dwroles.name as RoleName,'' as GroupName FROM dwsystem.dbo.DWUser inner join dwsystem.dbo.DWUserToRole on dwuser.uid=dwusertorole.uid inner join dwsystem.dbo.DWRoles on dwroles.rid=dwusertorole.rid
     UNION
     SELECT dbo.DWUser.name as UserName,dbo.DWRoles.name as RoleName,dbo.DWGroup.name as GroupName FROM dwsystem.dbo.DWUser inner join dwsystem.dbo.DWUserToGroup on dwuser.uid=dwusertogroup.uid inner join dwsystem.dbo.DWGroupToRole on dwgrouptorole.gid=dwusertogroup.gid inner join dwsystem.dbo.DWRoles on dwroles.rid=dwgrouptorole.rid inner join dwsystem.dbo.DWGroup on dwgrouptorole.gid= dwgroup.gid
     ) Userroles ORDER BY username,RoleName
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Note: File cabinet profile can also be added to the above query.