Effective Permissions

The effective permissions that a principal has on a securable are the result of the explicit permissions defined for that principal on that securable, the permissions defined on the parents of the securable, and the permissions that the principal inherits through role or group membership. Use the Effective Permissions dialog box to view the permissions that result when all the permissions of a principal on a securable are combined. The Effective Permissions dialog is read-only. Use the Securables pages to change permissions.

Options

  • Principal
    The principal name possessing the permissions listed in the Effective permissions grid.

  • Securable
    The name of the securable being examined.

  • Permission
    The type of permission.

  • Column
    Permission for a specific column of a table, view, or table-valued function. This is blank if the permission does not relate to a single column.