sp_grant_proxy_to_subsystem (Transact-SQL)

Artikel
2024-07-17

Applies to: SQL Server

Grants a proxy access to a subsystem.

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 ¹
`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

¹ 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

You can grant EXECUTE permissions on this procedure, but these permissions might 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

Dela via