A key focus of ArcGIS 10.1 is to simplify and streamline how you work with databases and geodatabases. We have listened to enhancement requests from you and developed easy-to-use interfaces for routine administration tasks such as managing privileges.
If you are the owner of a dataset, you can control which users can view or modify data in a database or geodatabase with privileges on datasets. Privileges can be set by user or by roles. Roles are a handy way to group users who have common workflows and responsibilities and should share a common set of privileges.
There are four types of privileges; select, update, insert, and delete.
- If you grant a user a select privilege on a dataset, that user can view and select rows in a table or features in a feature class but cannot perform any modifications to those entities
- An update privilege lets the user modify rows and features
- An insert privilege lets the user add new rows and features
- A delete privilege lets the user remove rows and features
At ArcGIS 10.1, the Privileges dialog box has been improved to let the owner of a dataset see all user privileges at a glance and quickly make changes. It also allows the owner to bulk grant privileges to multiple users at once.
To access the new Privileges dialog box, go to the Catalog tree and right-click on the dataset. Point to Manage, and click Privileges. You will see a list of database users and roles and the privileges granted to each. For each user and role, you can grant privileges to select, insert, update, and delete datasets in a database or datasets in a geodatabase.
Check out this video Brent Pierce and I put together to learn more about the Privileges dialog and how to use it.