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.


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


The name of the securable being examined.


The type of permission.


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.

Community Additions