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 15.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.
The Properties window has a page dedicated to permissions. ...
Get Microsoft SQL Server 2014 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.