Page History
...
- Enterprise level permissions
- SQL Server level permissions
- Individual user permissions
Assigned permissions are permissions that are explicitly granted or denied to a user, group, or role for a particular server or database object. A user, group, or role can have more than one permission assigned permission. Effective permissions are the net effect of assigned permissions, permissions inherited from the group or role membership, and covering permissions (SQL Server 2005 and later).
...
The following illustration depicts an example permissions scenario:
Experiencing irregularities when searching user and object permissions
...