dbo.sysproxylogin (Transact-SQL)
Applies to:
SQL Server
Shows 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. |
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.
Related content
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir