title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
dbo.sysproxylogin (Transact-SQL) |
dbo.sysproxylogin (Transact-SQL) |
VanMSFT |
vanto |
04/19/2024 |
sql |
system-objects |
reference |
|
|
|
[!INCLUDE SQL Server]
Shows 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. |
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.