Chapter 14
SQL Server Agent Security
Abstract
This chapter talks about the security within the SQL Server Agent
Keywords
SQL agent
SQL Server Agent
Information in this chapter
• Proxies
• SQL agent job steps
• Granting rights to proxies
• Job ownership
This chapter talks about the various permissions which can be used to allow non-privileged users to use some of the more powerful portions of the SQL Server Agent job system.
Proxies
Proxies are used by the SQL Server Agent to run job steps under specific Windows accounts which are different from the account which runs the SQL Server Agent. Proxies are created based on Credentials. To create a proxy, connect to the SQL Server instance using the object explorer. Within the object explorer ...
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.
