sp_xp_cmdshell_proxy_account (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
Creates a proxy credential for xp_cmdshell
.
Note
xp_cmdshell
is disabled by default. To enable xp_cmdshell
, see xp_cmdshell (server configuration option).
Transact-SQL syntax conventions
Syntax
sp_xp_cmdshell_proxy_account [ NULL | { 'account_name' , 'password' } ]
[ ; ]
Arguments
NULL
Specifies that the proxy credential should be deleted.
'account_name'
Specifies the Windows account to be the proxy.
'password'
Specifies the password of the Windows account.
Return code values
0
(success) or 1
(failure).
Remarks
The proxy credential is called ##xp_cmdshell_proxy_account##.
When it is executed using the NULL option, sp_xp_cmdshell_proxy_account
deletes the proxy credential.
Permissions
Requires CONTROL SERVER permission.
Examples
A. Create the proxy credential
The following example shows how to create a proxy credential for a Windows account called ADVWKS\Max04
with password ds35efg##65
.
EXEC sp_xp_cmdshell_proxy_account 'ADVWKS\Max04', 'ds35efg##65';
GO
B. Drop the proxy credential
The following example removes the proxy credential from the credential store.
EXEC sp_xp_cmdshell_proxy_account NULL;
GO
Related content
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za