sp_grant_proxy_to_subsystem (Transact-SQL)
Applies to:
SQL Server
Grants a proxy access to a subsystem.
Transact-SQL syntax conventions
Syntax
sp_grant_proxy_to_subsystem
[ [ @proxy_id = ] proxy_id ]
[ , [ @proxy_name = ] N'proxy_name' ]
[ , [ @subsystem_id = ] subsystem_id ]
[ , [ @subsystem_name = ] N'subsystem_name' ]
[ ; ]
Arguments
[ @proxy_id = ] proxy_id
The proxy identification number of the proxy to grant access for. @proxy_id is int, with a default of NULL
.
Either @proxy_id or @proxy_name must be specified, but both can't be specified.
[ @proxy_name = ] N'proxy_name'
The name of the proxy to grant access for. @proxy_name is sysname, with a default of NULL
.
Either @proxy_id or @proxy_name must be specified, but both can't be specified.
[ @subsystem_id = ] subsystem_id
The ID number of the subsystem to grant access to. @subsystem_id is int, with a default of NULL
.
Either @subsystem_id or @subsystem_name must be specified, but both can't be specified.
The following table lists the values for each subsystem.
Value | Description |
---|---|
2 |
ActiveX Script 1 |
3 |
Operating System (CmdExec ) |
4 |
Replication Snapshot Agent |
5 |
Replication Log Reader Agent |
6 |
Replication Distribution Agent |
7 |
Replication Merge Agent |
8 |
Replication Queue Reader Agent |
9 |
Analysis Services Query |
10 |
Analysis Services Command |
11 |
SSIS package execution |
12 |
PowerShell Script |
1 This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
[ @subsystem_name = ] N'subsystem_name'
The name of the subsystem to grant access to. @subsystem_name is sysname, with a default of NULL
.
Either @subsystem_id or @subsystem_name must be specified, but both can't be specified.
The following table lists the values for each subsystem.
Value | Description |
---|---|
ActiveScripting |
ActiveX Script |
CmdExec |
Operating System (CmdExec ) |
Snapshot |
Replication Snapshot Agent |
LogReader |
Replication Log Reader Agent |
Distribution |
Replication Distribution Agent |
Merge |
Replication Merge Agent |
QueueReader |
Replication Queue Reader Agent |
ANALYSISQUERY |
Analysis Services Query |
ANALYSISCOMMAND |
Analysis Services Command |
Dts |
SSIS package execution |
PowerShell |
PowerShell Script |
Remarks
Granting a proxy access to a subsystem doesn't change the permissions for the principal specified in the proxy.
Permissions
This stored procedure is owned by the db_owner role. You can grant EXECUTE
permissions for any user, but these permissions may be overridden during a SQL Server upgrade.
Examples
A. Grant access to a subsystem by ID
The following example grants the proxy Catalog application proxy
access to the ActiveX Scripting subsystem.
USE msdb;
GO
EXEC dbo.sp_grant_proxy_to_subsystem
@proxy_name = 'Catalog application proxy',
@subsystem_id = 2;
GO
B. Grant access to a subsystem by name
The following example grants the proxy Catalog application proxy
access to the SSIS package execution subsystem.
USE msdb;
GO
EXEC dbo.sp_grant_proxy_to_subsystem
@proxy_name = N'Catalog application proxy',
@subsystem_name = N'Dts' ;
GO