Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
iquttaineh
Starting Member
4 Posts |
 Posted - 2006-09-04 : 03:30:17
|
| Hi,I have a sharing folder on the server side, and the client must do a BULK INSERT and other read and write operations in the folder, so i want to give the permission only to the SQL-User and not to EVERYONE. Can you tell me please which user should i give the permission ?Thanx. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-04 : 03:43:11
|
| For this, you must create a Windows Group, where you put all allowed users in.This group, you give permission to read and write in the folder you mention.This way, you can substistute the user in SQL to the Windows group and use SSPI too!Peter LarssonHelsingborg, Sweden |
 |
|
|
iquttaineh
Starting Member
4 Posts |
Posted - 2006-09-04 : 03:55:43
|
| Dear Peter,I tried to add the client's PC Name, but also an sql error told me that i don't have a permission, but when i add EVERYBODY it succeeded, i don't want to add everybody, does the SQL use a specific user to do the SQL statements ? If yes what its name ?Thanx |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-04 : 06:06:00
|
| How can SQL tell you that you have no permission to add a user to a folder maintained by the operating system?Peter LarssonHelsingborg, Sweden |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-09-06 : 23:53:06
|
| what's the sql user? --if it's not a domain account, can you make it one? then you can remove everyone and add that account to access th folderhow are you doing the bulk? is it via jobs? if yes, add the sqlserver service account (should be domain) on the folder permission, else you can just set the maximum allowed connection to the folder to 1 and connect from the server so you'll get restrictionshope this helps...--------------------keeping it simple... |
|
|
|
|
|
|
|
|
Security Permissions ???