Views:
Question:
How do I check owner permissions on my Document Trays?
 
Answer:
The following queries can be run against your databases. They will return the name of the file cabinet and the associated users who currently have owner permissions;
 
MySQL: 
 

MySQL

USE DWSYSTEM;

SELECT DWFCProfile.name as 'Doc Tray', DWUser.name as 'User Name'
FROM DWFCProfile, DWFCProfileToUser, DWUser
WHERE DWFCProfile. fpid = DWFCProfileToUser.fpid
AND DWFCProfile.settings LIKE '%Admin_Operator%'
AND DWFCProfile.type like '%WebBasket%'
AND DWFCProfileToUser.uid = DWUser.uid
 

MSSQL:
 

MSSQL

USE DWSYSTEM;
GO
SELECT DWFCProfile.name as 'Doc Tray', DWUser. name as 'User Name'
FROM DWFCProfile, DWFCProfileToUser, DWUser
WHERE DWFCProfile.fpid = DWFCProfileToUser.fpid
AND CAST(DWFCProfile. settings as nvarchar(max) ) LIKE '%Admin_Operator%'
AND DWFCProfile. type like '%WebBasket%'
AND DWFCProfileToUser.uid = DWUser.uid

 

KBA is applicable to On-Premise Organizations ONLY.
This article is valid for DocuWare versions: 7.3, 7.4, 7.5, 7.6, 7.7, 7.8, 7.9, 7.10, 7.11, 7.12, 7.13, Check owner, Permissions, Document Trays
Comments (0)