Export (0) Print
Expand All

dbo.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.

Applies to: SQL Server (SQL Server 2008 through current version).

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

Only members of the sysadmin fixed server role can access this table.

Community Additions

ADD
Show:
© 2014 Microsoft