sp-revoke-login-from-proxy-transact-sql.md

title	sp_revoke_login_from_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_revoke_login_from_proxy_TSQL sp_revoke_login_from_proxy
dev_langs	TSQL
helpviewer_keywords	sp_revoke_login_from_proxy
ms.assetid	e4546c13-9fba-4bab-8b42-d6f18b33ec25
author	VanMSFT
ms.author	vanto

sp_revoke_login_from_proxy (Transact-SQL)

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

Removes access to a proxy for a security principal.

Transact-SQL Syntax Conventions

Syntax

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

Arguments

[ @name = ] 'name' The name of the [!INCLUDEssNoVersion] login, server role, or msdb database role to remove access for. name is nvarchar(256) with no default.

[ @proxy_id = ] id The id of the proxy to remove access for. Either id or proxy_name must be specified, but both cannot be specified. The id is int, with a default of NULL.

[ @proxy_name = ] 'proxy_name' The name of the proxy to remove access for. Either id or proxy_name must be specified, but both cannot be specified. The proxy_name is sysname, with a default of NULL.

Return Code Values

0 (success) or 1 (failure)

Remarks

Jobs that are owned by the login that references this proxy will fail to run.

Permissions

To execute this stored procedure, a user must be a member of the sysadmin fixed server role.

Examples

The following example revokes access for the login terrid to access the proxy Catalog application proxy.

USE msdb ;  
GO  
  
EXEC dbo.sp_revoke_login_from_proxy  
    @name = N'terrid',  
    @proxy_name = N'Catalog application proxy' ;  
GO  

See Also

SQL Server Agent Stored Procedures (Transact-SQL)
sp_grant_login_to_proxy (Transact-SQL)
sp_help_proxy (Transact-SQL)