| title | dbo.sysproxylogin (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 06/10/2016 | ||||
| ms.prod | sql-non-specified | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 433d33cb-bdf2-47bb-af78-2a40b7c8dfce | ||||
| caps.latest.revision | 14 | ||||
| author | JennieHubbard | ||||
| ms.author | jhubbard | ||||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]
Records which [!INCLUDEssNoVersion] logins are associated with each SQL Server Agent proxy account. This table is stored in the msdb database.
| Column name | Data type | Description |
|---|---|---|
| proxy_id | int | ID of the [!INCLUDEssNoVersion] Agent proxy account. This value corresponds to the proxy_id column in the sysproxies table. |
| sid | varbinary(85) | Microsoft Windows security_identifier for the SQL Server login. |
| principal_id | int | ID of the user or group that has permission to use the proxy account for a specified subsystem step. |
| flags | int | Type of login: 0 = Windows user or group, and [!INCLUDEssNoVersion] login. 1 = [!INCLUDEssNoVersion] fixed system role 2 = msdb database role |
Only members of the sysadmin fixed server role can access this table.