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

Description

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.

Cause

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.