About Me

Barking, Essex, United Kingdom
MCITP DBA ,MCITP BI & Oracle OCP 11G

Tuesday, February 24, 2015

XPcmdshell Permission issue for Non-Sysadmin users and access to network share


To enable the command shell 

-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1;
GO
-- To update the currently configured value for advanced options.
RECONFIGURE;
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1;
GO
-- To update the currently configured value for this feature.
RECONFIGURE;

GO

EXEC sp_xp_cmdshell_proxy_account '[Domain\username]','passw0rd'

use master
go
CREATE USER [Domain\username] FROM LOGIN [Domain\username]


GRANT EXECUTE ON xp_cmdshell TO [Domain\username]

No comments:

Post a Comment