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. ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
