Column Permissions

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.

  • Principal
    The user or role for which you are setting permission.

  • Table or View Name
    The table or view that contains the columns.

  • Permission
    The type of permission being set.

Permissions Grid

Select or clear the Allow and Deny check boxes to configure the permissions.

  • 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.