Problem: Unable to assign privileges to specific users for feature datasets in SQL Server using the Change Privileges tool


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.


This problem occurs due to the following reasons:

  • 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 ArcGIS Help: Enterprise geodatabase size and name limits.

Solution or Workaround

There are two possible solutions for this 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.
    Since the relationship class is also a database object, ensure the relationship class name in the geodatabase does not exceed 31 characters in length.

Related Information