sys.sp_revoke_proxy_from_subsystem

Description

Revokes access to a subsystem from a proxy. The proxy identification number of the proxy to revoke access from. must be specified, but both can’t be specified.

Syntax

sp_revoke_proxy_from_subsystem
[ [ @proxy_id = ] proxy_id ]
[ , [ @proxy_name = ]
N
'proxy_name'
]
[ , [ @subsystem_id = ] subsystem_id ]
[ , [ @subsystem_name = ]
N
'subsystem_name'
]
[ ; ]

Examples

Example 1

Catalog application proxy

Example 2

USE msdb;
GO
EXECUTE dbo.sp_revoke_proxy_from_subsystem
@proxy_name =
'Catalog application proxy'
,
@subsystem_name = N
'Dts'
;