Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Windows User of SQL Stored Procedure executor Expand / Collapse
Posted Monday, November 17, 2008 5:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 27, 2009 1:41 AM
Points: 1, Visits: 13
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?

Post #603599
Posted Tuesday, November 18, 2008 9:09 AM

Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, September 16, 2016 11:44 AM
Points: 6,639, Visits: 1,905
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, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security),
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #604492
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse