sysproxylogin (Transact-SQL)
Records which SQL Server 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 SQL Server 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 SQL Server login. 1 = SQL Server fixed system role 2 = msdb database role |
Remarks
Only members of the sysadmin fixed server role can access this table.