.png)
Permissions or Securables Page
Use the Permissions page or the Securables page to view or set the permissions for securables. This page can be opened from many locations. The contents of the page can change slightly, depending on how the page is opened and what it contains. The top grid of the page might be populated when the page opens, or it might be empty. To add items to the upper grid, click Search. In the upper grid, select an item, and then set the appropriate permissions on the Explicit tab. To view aggregated permissions, use the Effective tab.
To understand the possible combinations of securables and principals, see the securable-specific syntax links in the topic GRANT (Transact-SQL). Other topics that you can refer to help you understand permissions are: Permissions Hierarchy (Database Engine), Securables, and Permissions (Database Engine).
The upper grid contains one or more items for which permissions can be set. This dialog box provides the Search button for selecting objects or principals to add to the upper grid. The name of the grid might display Securables or one or more types of securables or principals. The columns that are displayed in the upper grid vary depending on the principal or securable.
The permissions that a principal has related to a securable may come from permissions that are set for several different principals. For example, a login might be granted permissions individually and also as a member of a group. The Effective tab shows the result of combining explicit permissions and the permissions that are received from group or role memberships. Grant permissions are aggregated. A deny permission overrides all grant permissions.
