Altering dataset permission in ArcSDE geodatabases for SQL Server Express

A user's permissions on datasets in an ArcSDE geodatabase for SQL Server Express are altered by assigning the user to one of three roles: None, Read Only, or Read/Write.

The following rules apply to assigning dataset permissions to users:

• Only the owner of the dataset can alter permissions on it.
• Only the owner of a dataset can drop the dataset or alter its definition; therefore, even if the owner of the dataset grants read/write privileges on a dataset to another user, that user cannot alter the schema of the dataset.
• You can only alter a user's permissions on one dataset at a time.
• It is not possible to grant a user different permissions to feature classes within a feature dataset.

Tip:

If you choose a user from the list who is in the geodatabase or server administrator roles, a message appears indicating the user has higher-level permissions and all dataset permissions options are deactivated. Since you cannot deny a user access to specific objects but only grant permission to specific objects, if you do not want the user to have read/write access to all objects in the geodatabase, you need to change his or her rights on the geodatabase to read only then grant read/write permissions to only those datasets to which you want him or her to have read/write access.

Steps:

1. In the Catalog tree, connect to the geodatabase that contains the dataset for which you want to alter privileges.

   Be sure you are connected as the owner of the dataset.

2. Right-click the dataset for which you want to give specific privileges to another user.
3. Click Manage and click Privileges.

   The dataset Permissions dialog box opens.

4. From the Database Server Users list, choose the user or group to which you want to grant permissions on the dataset.
5. Click the permission you want to grant for this dataset to this user or group (None, Read Only, or Read/Write).
6. Click Apply.
7. Click OK to close the dialog box.

The permissions for that user on that specific dataset are altered.