I'd like to know how can i give grant to a specific user to execute xp_cmdshell.
This user as one stored procedure that invoques the xp_cmdshell, we cant give him sysadmin privs so:
- Can i give this user one specific grant to execute this extended stored procedure?
- Can i become the owner of that stored procedure and give him privileges to execute the SP?
- Should i use any other option like create the same process with the use of one DTS or anyother option?
Thanks and regards