Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Office 2007 changes acl file permissions on a Samba server

Posted on 2010-09-16
3
Medium Priority
?
726 Views
Last Modified: 2012-05-10
I took a .xls file and set the following permissions as seen by getfacl

# file: test.xls
# owner: root
# group: users
user::rwx
user:root:rwx
user:administrator:rw-
group::rw-
group:users:rw-
group:domain\040users:rw-
mask::rwx
other::---

Then I opened the file using Excel 2007, changed it, saved it and this is what I get afterwards

# file: test.xls
# owner: gjohn
# group: domain\040users
user::rw-
user:root:rwx
user:administrator:rw-
group::rw-
group:users:rw-
mask::rwx
other::---

I tested a plain text file using vim connecting to the share over NFS and using notepad over SMB and neither modify the acl permissions so I can only assume that Excel is to blame. Is there anyway to prevent this from happening?
0
Comment
Question by:coanda
  • 2
3 Comments
 
LVL 11

Accepted Solution

by:
ProfessorBindokas earned 1000 total points
ID: 33699893
Hi, thanks for asking this question, since it's one that caused me to pull out quite a few hairs in the past.  Unfortunately, it's not an Excel issue, but a problem common to Microsoft Office and OpenOffice in general.  Our view is that the problem is caused by Office's specific way of handling files - when opened for editing, a temporary file is created while editing and when a save occurs, the temp file is converted, completely replacing the existing file with a new version, effectively overwriting the ACL.

Found no way of handling this on SAMBA, since file replacing is a fully "acceptable" operation for the server itself.  The only way we found around it in term of preserving file ownership information was to start using a subversion system in lieu of a simple fileserver.  That gave full control for access plus info on who created, edited, when, etc.
0
 
LVL 3

Author Comment

by:coanda
ID: 33703390
I will agree that this problem plagues all versions of Office/Excel, but not Office type files in general. As can be seen below OOo has no problems from Windows or Linux preserving ACL file permissions.

Using OpenOffice.org 3.2 from Ubuntu 10.04

acl permissions before save:
-----------------------------------

gjohn@gjohn:/mnt/public/archive$ getfacl test.xls
# file: test.xls
# owner: root
# group: users
user::rw-
user:administrator:rw-
user:gjohn:rw-
group::rw-
group:users:rw-
group:domain\040users:rw-
mask::rwx
other::---

acl permissions after save:
---------------------------------

gjohn@gjohn:/mnt/public/archive$ getfacl test.xls
# file: test.xls
# owner: root
# group: users
user::rw-
user:administrator:rw-
user:gjohn:rw-
group::rw-
group:users:rw-
group:domain\040users:rw-
mask::rwx
other::---

Using OpenOffice.org 3.0 from Windows XP

acl permissions after save:
--------------------------------

gjohn@gjohn:/mnt/public/archive$ getfacl test.xls
# file: test.xls
# owner: root
# group: users
user::rw-
user:administrator:rw-
user:gjohn:rw-
group::rw-
group:users:rw-
group:domain\040users:rw-
mask::rwx
other::---

Using Excel 2002 SP3 from Windows XP

acl permissions after save:
---------------------------------

gjohn@gjohn:/mnt/public/archive$ getfacl test.xls
# file: test.xls
# owner: gjohn
# group: domain\040users
user::rw-
user:root:rw-
user:administrator:rw-
group::rw-
group:users:rw-
mask::rwx
other::---

I personally use a version control system for the work that I do, but asking your coworkers to completely change the way they work is not always greeted with enthusiasm.
0
 
LVL 3

Author Closing Comment

by:coanda
ID: 33736937
Unfortunately I've not been able to find any better information WRT my problem.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

885 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question