Sam,
We are on 6.11, SQL Server, on premise. So, a query of the database gets us the information we need, at least the basic add, edit, view, and delete capabilities by user/group and file cabinet. The queries are fairly complicated, but here they are, run against the
dwsystem database of your SQL Server:
For GROUP permissions:
SELECT G.Name AS GroupName, R.Name AS RoleName, FC.Name AS FileCabinetName, FCP.Name AS Permission
FROM DWGroup G INNER JOIN DWGroupToRole GR ON G.gid = GR.gid
INNER JOIN DWRoles R ON GR.rid = R.rid
INNER JOIN DWFCProfileToRole FCPR ON R.rid = FCPR.rid
INNER JOIN DWFCProfile FCP ON FCPR.fpid = FCP.fpid
INNER JOIN DWFileCabinet FC ON FCP.fid = FC.fid
WHERE G.oid = 1 AND G.type = 1 AND G.Active = 1
AND R.type = 1 AND R.active = 1
AND UPPER(FCP.Type) LIKE '%FCPROFILE%'
ORDER BY G.Name, R.Name, FC.Name, FCP.Name
For USER permissions:
SELECT U.Name AS UserName, FC.Name AS FileCabinetName, FCP.Name AS Permission
FROM DWUser U INNER JOIN DWFCProfileToUser FCPU ON U.uid = FCPU.Uid
INNER JOIN DWFCProfile FCP ON FCPU.fpid = FCP.fpid
INNER JOIN DWFileCabinet FC ON FCP.fid = FC.fid
WHERE U.oid = 1 AND U.Active = 1
AND UPPER(FCP.Type) LIKE '%FCPROFILE%'
ORDER BY U.Name, FC.Name, FCP.Name
If you do not have access to the database, or if the structures have changed between 6.9 and 6.11, you may be out of luck. But these queries return a handy listing of groups and users and the permissions they have for file cabinets.
Do note that if your security setup is more convoluted (as in you use a lot of complex, custom-built Profiles) this data will probably be of less use to you. But if you keep things fairly vanilla, it generates a nice summary of what people can see.
Hope this helps!
Thanks,
Joe Kaufman
