Windows User of SQL Stored Procedure executor

  • I've created a procedure that accesses a windows shared folder.

    When the folder is shared for Everyone, the SP works fine.

    But i want to restrict the sharing permission.

    Could anyone advise me, for which user i've to provide the Sharing Permission?

    Arun

  • I'm guessing you're using xp_cmdshell to access the folder? If so, it'll be the SQL Server service account which needs privileges if this procedure is called by someone with sysadmin level privileges. If it's called by regular users, I'm assuming you've already set up the proxy account. In that case, it would also need to be accessible by that proxy account (if it is different).

    K. Brian Kelley
    @kbriankelley

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply