When attempting to set privileges using the Change Privileges tool to allow certain users to view, edit or create data for feature datasets in SQL Server, the tool fails.
Reasons the problem occurs:
- The dataset owner sets privileges using an ArcGIS for Desktop Basic license. The ArcGIS for Desktop Basic license does not support the Change Privileges tool.
- The tool is unable to grant privileges if the user name has more than 31 characters. The set number of characters allowed in the SQL Server database object name is limited to 31. For more information, refer to ArcMap: Enterprise geodatabase size and name limits.
Solution or Workaround
There are two possible solutions for the issue, depending on the cause.
- Apply an ArcGIS for Desktop Standard or Advanced license, or upgrade to ArcGIS for Desktop Standard or Advanced.
- Verify the length of the user name before granting permissions for the feature dataset.