Chapter 13
Server Rights
Abstract
This chapter talks about the permissions that various people should have on the production SQL Servers, as well as talking about the risks of running command line services.
Keywords
permissions
OS rights
windows services
Information in this chapter
• OS rights needed by the SQL server service
• OS rights needed by the DBA
• OS rights needed to install service packs
• OS rights needed to access SSIS remotely
• Console apps must die
• Default sysadmin rights
• Vendor’s and the sysadmin fixed server role
This chapter talks about the permissions that various people should have on the production SQL Servers, and about the risks of running command line services.
When working with Microsoft Azure SQL Database, ...
Get Securing SQL Server, 3rd Edition 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.
