Use the ColumnPermissions page to set this user's permissions for individual columns in a table or view. Click Add Objects to add database objects to the upper Objects grid. Select each object in the Objects grid, and then set the appropriate permissions in the Permissions grid.
The user or role for which you are setting permission.
- Table or View Name
The table or view that contains the columns.
The type of permission being set.
Select or clear the Allow and Deny check boxes to configure the permissions.
Set each type of permission to Allow, Deny, or neither. Deny will override any other settings. If neither Allow nor Deny is selected, permissions, if any, will be inherited from other group memberships.