Granting and Revoking Permissions to Modify Database Objects

Go Up to Establishing Database Security

After you have created users and roles you can grant or revoke their permissions to insert, select, update, delete, reference, and alter entities, tables, attributes, columns, and views.

1. In the Data Model Explorer, double-click an object to invoke the editor.
2. Click the Permissions tab.
3. Select a role or user.
4. Select an operation or click the column header to select the entire range of operations.
5. You can select multiple operations by holding CTRL+Alt down while clicking the operations.
6. Click Grant or Revoke.
7. Click OK to exit the editor

• Keep in mind that the more specific permissions are, the more time you may have to spend maintaining and updating them.

See Also

• Creating and Editing Database Users
• Creating and Editing Database Roles
• Changing Database Users Associated with Existing Database Roles