Lost Document Management Permissions

[Steve Van Dyke]

How many of us have lost the ability to set Document Management Permissions by removing All Users and the Add and Remove buttons are grayed out. Here is a helpful tip.


Perform the following steps in Microsoft SQL to restore permissions for ‘All Users’ in this project.

Please Note: This Tip assumes you have basic knowledge of Microsoft SQL and you have backed up a copy of your database prior to making any changes. It is also assumed you take full responsibility any changes made on the backend. If you wish, also backup and restore a copy of your database as a trial run in a test environment.

Logon to SQL and display the tables for your Prolog Database. Find the following information from the relevant tables:

Projects – Locate the ProjectID for the project in question.
Select * from Projects where Name like ‘projectname’

Next, from the WS_Folders table – Locate the ‘Project Documents’ folder for that project.
SELECT * FROM WS_Folders WHERE FolderName LIKE 'project documents' and ProjectID = ID from Projects Query above.

You can also list out the FolderID’s for Project Documents for all projects if this is easier.

SELECT WS_Folders.FolderID, WS_Folders.FolderName, WS_Folders.ProjectID AS FolderProjectID, Projects.ProjectID AS ProjectProjectID,
Projects.Name
FROM WS_Folders INNER JOIN
Projects ON WS_Folders.ProjectID = Projects.ProjectID
WHERE (WS_Folders.FolderName = N'project documents')


In the WS_FolderFileSecurity table – Add the following Detail for a new entry to this table:

The ID is System Generated so leave this column as is.
To represent ‘All Users’ the UserID is NULL and GroupID is NULL
Enter the FolderID from your Query above.
In the Access column enter 4095 (This is Full Permissions minus Use Folder Permissions)

You may need to close and open Document Management to see the change, but the All Users Group should once again have Full Permissions to Project Documents. From here, you can set proper permissions as desired.