sp-enum-login-for-proxy-transact-sql.md

title	sp_enum_login_for_proxy (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_enum_login_for_proxy_TSQL sp_enum_login_for_proxy
dev_langs	TSQL
helpviewer_keywords	sp_enum_login_for_proxy
ms.assetid	62a75019-248a-44c8-a5cc-c79f55ea3acf
ms.author	vanto
author	VanMSFT

sp_enum_login_for_proxy (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Lists associations between security principals and proxies.

Transact-SQL Syntax Conventions

Syntax

sp_enum_login_for_proxy  
    [ @name = ] 'name'  
    [ @proxy_id = ] id,  
    [ @proxy_name = ] 'proxy_name'  

Arguments

[ @name = ] 'name' The name of a [!INCLUDEssNoVersion] principal, login, server role, or msdb database role to list proxies for. The name is nvarchar(256), with a default of NULL.

[ @proxy_id = ] id The proxy identification number of the proxy to list information for. The proxy_id is int, with a default of NULL. Either the id or the proxy_name may be specified.

[ @proxy_name = ] 'proxy_name' The name of the proxy to list information for. The proxy_name is sysname, with a default of NULL. Either the id or the proxy_name may be specified.

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column name	Data type	Description
proxy_id	int	Proxy identification number.
proxy_name	sysname	The name of the proxy.
name	sysname	Name of the security principal for the association.
flags	int	Type of the security principal. 0 = [!INCLUDEssNoVersion] login 1 = Fixed system role 2 = Database role in msdb

Remarks

When no parameters are provided, sp_enum_login_for_proxy lists information about all logins in the instance for every proxy.

When a proxy id or proxy name is provided, sp_enum_login_for_proxy lists logins that have access to the proxy. When a login name is provided, sp_enum_login_for_proxy lists the proxies that the login has access to.

When both proxy information and a login name are provided, the result set returns a row if the login specified has access to the proxy specified.

This stored procedure is located in msdb.

Permissions

Execution permissions for this procedure default to members of the sysadmin fixed server role.

Examples

A. Listing all associations

The following example lists all permissions established between logins and proxies in the current instance.

USE msdb ;  
GO  
  
EXEC dbo.sp_enum_login_for_proxy ;  
GO  

B. Listing proxies for a specific login

The following example lists the proxies that the login terrid has access to.

USE msdb ;  
GO  
  
EXEC dbo.sp_enum_login_for_proxy  
    @name = 'terrid' ;  
GO  

See Also

sp_help_proxy (Transact-SQL)
sp_grant_login_to_proxy (Transact-SQL)
sp_revoke_login_from_proxy (Transact-SQL)