Database Role Properties (Permissions Tab)
Use this tab to view or specify the following options.
Options
Database role
Select the database role for which to view or modify permissions.
List all objects
List all objects in the database. Click the appropriate box to modify role permissions.
List only objects with permissions for this role
Specify permissions only for objects with permission in the database. Click the appropriate box to modify role permissions. This may be helpful if there are many objects, and you only need to view or modify the objects with permissions for the selected role.
Object
Specify the permissions for the selected object. You can grant or remove permissions to execute SELECT, INSERT, UPDATE, DELETE, EXEC statements. You can also grant or remove permissions to execute Declarative Referential Integrity (DRI) constraints. For more information on Declarative Referential Integrity constraints, see Parts of a Database.
Columns
Display the Column Permissions dialog box, which allows you to manage permissions for the object on a column-by-column basis.