Microsoft® SQL Server 2012 Unleashed

Using SSMS to Manage Permissions at the Object Level

The last permission assignment we look at is the object level. SSMS enables you to select a specific object instance in the Object Explorer and assign permissions to it. This method allows you to navigate to the object you want via the Object Explorer tree and assign permissions accordingly. Figure 17.19 shows the Object Explorer tree expanded to the Stored Procedures node. A specific stored procedure has been right-clicked, and the Properties option has been selected.

FIGURE 17.19 Object-level permissions selected via Object Explorer.

The Properties window has a page dedicated to permissions. ...