Dear all,
I created a login name xxx and assigned few permisson on database <xyz>.
Now i want to grant execute permission to user xxx on extended stored procedure xp_cmdshell.
Without creating user in master database is there other way to grant the same to user xxx.
Regards
Mohd Sufian
Using xp_cmdshell requires a high level of permissions.
You can create a proxy account for xp_cmdshell, put the use of xp_cmdshell into a stored procedure, and then give your user permission for the stored procedure.
Check in Books Online about xp_cmdshell and proxy accounts.
No comments:
Post a Comment