Applies To: SQL Server 2014, SQL Server 2016 Preview
Removes access to a proxy for a security principal.
Applies to: SQL Server (SQL Server 2008 through current version).
- [ @name = ] 'name'
The name of the SQL Server 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.
0 (success) or 1 (failure)
Jobs that are owned by the login that references this proxy will fail to run.
To execute this stored procedure, a user must be a member of the sysadmin fixed server role.
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