File Permissions keep resetting...

[Ben-UK]

Hello,

 

Got a strange problem with file permissions on our 2008 R2 server.

 

The file is located in path \\server\shared area\department\excelfile.xls

 

 

Permissions on the excel file are currently inherited from the folder above.

 

 

I have to go advanced the change permissions and untick include inheritable perssmions.

 

This now allows me to edit the users who need access.

 

I set the sercuity permissions as,

 

SYSTEM = FULL

Administrators (server\administrators) = FULL

User 1 = Modify

User 2 = Modify

User 3 = Modify

User 4 = Modify

 

Now the problem appears

 

Any of the 4 users open the file, make a change and save. It resets the sercuity permissions, just wipes out what i set above.

 

When any of the users make that change they appear in the sercuity permissions with full control and become the owner.

 

Even if i go to advanced permissions and set a deny on the Take Ownership for the user it still over rides it.

 

Anyone see this before or am i missing something simple...

 

 

If you need anymore info just let me know.

 

Thanks Ben

[adrian_costea]

Strange, I tested this in my lab and could not reproduce. Try creating another share with another file and ask one of the users to edit the file. See what happens.

[DMcCoy]

Any of the 4 users open the file, make a change and save. It resets the sercuity permissions, just wipes out what i set above.

 

It doesn't reset the permissions, but the excel save process deletes the file and renames a new temporary file to take it's place, which is why the permissions are lost each time.

[ChrisMiles]

It doesn't reset the permissions, but the excel save process deletes the file and renames a new temporary file to take it's place, which is why the permissions are lost each time.

 

What he said. You REALLY should not do this though, it can cause all sorts of problems, the temp file having different permissions to the document is just one example. Create a folder for this document and set permissions on that or consider if the file is in the right place at all if it is mixed up with other files used by people who should not access it.

[Ben-UK]

Thanks for the replies.

 

I understand what your saying about the excel temp file during the save process. So i over come this by setting the permissions on the folder containing the excel file ??

[plexer]

Thanks for the replies.

 

I understand what your saying about the excel temp file during the save process. So i over come this by setting the permissions on the folder containing the excel file ??

 

Yes

 

Ben