Using SSMS to Manage Permissions at the Server Level
Logins can be granted explicit permissions at the server level. Earlier we looked at fixed server roles as one means for assigning permissions, but you can manage individual server-level securables as well. Figure 17.11 shows the Login Properties window for a login named Chris. You launch this window by right-clicking the login and selecting Properties. Figure 17.11 shows the Securables page, which allows you to add specific securables to the grid.
FIGURE 17.11 Server-level permissions.
Note
You can open a Permissions page like the one shown in Figure 17.11 from many different places in the ...
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.
