Chapter 12
Server Rights
Information in this chapter:
• SQL Server Service Account Configuration
• 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
• Fixed-Server Roles
• User Defined Server Roles
• Fixed Database Roles
• User Defined Database Roles
• Default sysadmin Rights
• Vendor’s and the sysadmin Fixed-Server Role
• Summary
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’s SQL Azure, as of the writing of this book, in spring 2012 the only section of this chapter that ...
Get Securing SQL Server, 2nd 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.
