Public
Worksite permissions default to everyone have access to everything. When a workspace is set to Public no permissions are restricted every if they are listed in the security list
Private
Private mode restricts access per the permissions listed
FAQ
Read/Write Permission vs Full Access
Full Access gives users permissions to change existing permissions. Read/Write gives full access to the data
How do I give users read Access to a Workspace
Set it as Private
Great a group with all users and assign this read
Setup Users to full access
How can I get a list of all private or public workspaces?
SELECT p.prj_id, p.prj_name, p.prj_descript, p.prj_owner FROM
mhgroup.projects p (NOLOCK) WHERE p.subtype = 'work' AND
p.default_security = 'X'
To get a list of public workspaces you would change p.default_security = ‘X’ to ‘P’.
SELECT p.prj_id, p.prj_name, p.prj_descript, p.prj_owner FROM
mhgroup.projects p (NOLOCK) WHERE p.subtype = 'work' AND
p.default_security = 'P'
Loading...