Udostępnij za pośrednictwem

dbo.sysproxylogin (Transact-SQL)

  • Artykuł

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

Uwagi

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

Zobacz także

Odwołanie

dbo.sysproxies (Transact-SQL)