Skip to content

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

Latest commit

 

History

History
113 lines (85 loc) · 4.36 KB

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

File metadata and controls

113 lines (85 loc) · 4.36 KB
title sp_enum_proxy_for_subsystem (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-non-specified
ms.reviewer
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic language-reference
f1_keywords
sp_enum_proxy_for_subsystem_TSQL
sp_enum_proxy_for_subsystem
dev_langs
TSQL
helpviewer_keywords
sp_enum_proxy_for_subsystems
ms.assetid 580cc3be-1068-4a96-8d15-78ca3a5bb719
caps.latest.revision 27
author JennieHubbard
ms.author jhubbard
manager jhubbard

sp_enum_proxy_for_subsystem (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx_md]

Lists permissions for [!INCLUDEssNoVersion] Agent proxies to access subsystems.
Applies to: [!INCLUDEssNoVersion] ([!INCLUDEssKatmai] through current version).

Topic link icon Transact-SQL Syntax Conventions

Syntax

  
sp_enum_proxy_for_subsystem  
    [ @proxy_id = ] proxy_id,  
    [ @proxy_name = ] 'proxy_name',  
    [ @subsystem_id = ] subsystem_id,  
    [ @subsystem_name = ] 'subsystem_name'

Arguments

[ @proxy_id = ] proxy_id
The 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.

[ @subsystem_id = ] subsystem_id
The identification number of the subsystem to list information for. The subsystem_id is int, with a default of NULL. Either the subsystem_id or the subsystem_name may be specified.

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

Return Code Values

0 (success) or 1 (failure)

Result Sets

Column name Data type Description
subsystem_id int Subsystem identification number.
subsystem_name sysname The name of the subsystem.
proxy_id int Proxy identification number.
proxy_name sysname The name of the proxy.

Remarks

When no parameters are provided, sp_enum_proxy_for_subsystem lists information about all proxies in the instance for every subsystem.

When a proxy id or proxy name is provided, sp_enum_proxy_for_subsystem lists subsystems that the proxy has access to. When a subsystem id or subsystem name is provided, sp_enum_proxy_for_subsystem lists proxies that have access to that subsystem.

When both proxy information and subsystem information is provided, the result set returns a row if the proxy specified has access to the subsystem 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 proxies and subsystems for the current instance.

USE msdb ;  
GO  
  
EXEC dbo.sp_enum_proxy_for_subsystem ;  
GO

B. Determining if a proxy has access to a specific subsystem

The following example returns a row if the proxy Catalog application proxy has access to the ActiveScripting subsystem. Otherwise, the example returns an empty result set.

USE msdb ;  
GO  
  
EXEC dbo.sp_enum_proxy_for_subsystem  
    @subsystem_name = 'ActiveScripting',  
    @proxy_name = 'Catalog application proxy' ;  
GO

See Also

sp_grant_proxy_to_subsystem (Transact-SQL)