Online Documentation for SQL Administrator for SQL Server
Proxies
A Microsoft® SQL Server Agent proxy defines the security context for a job step. A proxy provides SQL Server Agent with access to the security credentials for a Microsoft Windows user. Each proxy can be associated with one or more subsystems. A job step that uses the proxy can access the specified subsystems by using the security context of the Windows user. Before SQL Server Agent runs a job step that uses a proxy, SQL Server Agent impersonates the credentials defined in the proxy, and then runs the job step by using that security context.
SQL Server proxies can be used to help database administrators ensure that each job step runs with the minimum permissions required to perform its task.
Note: Before using SQL Server proxies, make sure that the SQL Server Agent service is running.
Use the object context menu or toolbar buttons to:
create a new proxy
edit selected proxy(ies)
drop selected proxy(ies)
create and print the report
- rename proxy
- enable proxy(ies)
- disable proxy(ies)
The list displays all existing proxies as a grid with the following columns: Name, Credential, Enabled, Description. If more convenient, you can change the order of the columns by dragging their headers horizontally. See the Working with grid section of the SQL Administrator documentation to find out operations that can be performed with the grid.
The drop-down menu on the toolbar allows you to browse among the subsystems to display only those proxies which are granted to the selected subsystem.
To open a proxy in Proxy Editor, double-click it in the list of proxies. Alternatively, you can right-click the proxy alias and select the Edit Proxy context menu item.
See also:
