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.

See Also

Reference

sysproxies (Transact-SQL)