December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 Unleashed
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...