Skip to Main Content
Securing SQL Server, 3rd Edition
book

Securing SQL Server, 3rd Edition

by Denny Cherry
April 2015
Intermediate to advanced content levelIntermediate to advanced
462 pages
13h 59m
English
Syngress
Content preview from Securing SQL Server, 3rd Edition
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 ...
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,
and much more.
Start your free trial

You might also like

Securing SQL Server: DBAs Defending the Database

Securing SQL Server: DBAs Defending the Database

Peter A. Carter
SQL Server 2019 Administration Inside Out

SQL Server 2019 Administration Inside Out

Randolph West, Melody Zacharias, William Assaf, Sven Aelterman, Louis Davidson, Joseph D’Antoni

Publisher Resources

ISBN: 9780128012758