• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 566
  • Last Modified:

Excel ACL File Permission

I have an excel file on a shared network drive that needs to be used by 2 groups of people. Group A should have read/write access. The other, Group B, only read access.
All users in the group are Authenticated Users of the domain.

I've set the NTFS permission on the excel file to the following:
Administrators - Full Control
Group B - Full Control
Users(MACHINE\Users) - Read & Execute + Read

I would assume that any users belonging to Group B would be able to make changes and save those changes to the excel file.
However, when the users open the excel file, they automatically open as Read-only.
Only Administrators are able to open the file normally.

What did I do wrong?
0
frukeus
Asked:
frukeus
  • 4
  • 4
  • 2
3 Solutions
 
Debsyl99Commented:
Hi frukeus,
This may sound obvious so sorry but doesn't hurt to check - ensure that the share permissions aren't set to read only for everyone.

Deb :))
0
 
Jay_Jay70Commented:
Hi frukeus,

also worth checking that your file isnt set to be inheriting permissions from the folder as they may start having conflictions if one says one thing and one says another, check your propogation settings on the folder and your inheritance settings on the file :)

Hello Deb
0
 
frukeusAuthor Commented:
I've checked...the share permissions is Full Control for Everyone.

For the NTFS permission, it is applied directly to my file and not inherited from the folder. As stated previously, only the 3 permissions are set on the file.
0
Worried about phishing attacks?

90% of attacks start with a phish. It’s critical that IT admins and MSSPs have the right security in place to protect their end users from these phishing attacks. Check out our latest feature brief for tips and tricks to keep your employees off a hackers line!

 
Jay_Jay70Commented:
and your folder propogation settings?
0
 
frukeusAuthor Commented:
I don't really get the folder propogation settings. Where do I check?
0
 
Debsyl99Commented:
Check the folder itself and any other's that it is contained in - security, advanced tab. Check the permissions are set for this folder only as opposed to "apply to this folder, subfolders and files ". If in xp you may also be able to view the effective permissions against that file.
0
 
Jay_Jay70Commented:
under advanced under security TAB of the parent folder - make sure that the "replace permissions....." isnt configured, be default it shouldnt be i just want to check
0
 
frukeusAuthor Commented:
Oh yes, permissions are not replaced on child objects....I've made sure of that.

The thing is that I've noticed that the permissions were eventually applied after some time. After setting the permissions for a few hours, it took effect. What is strange is this delay only occurs for Group permissions. If I apply the permission directly for a user, it will occur immediately.

Eg. Group B has members User A.

If I allow permissions for User A to read/write on the file, it is effective immediately.
However, if I apply Group B permissions for read/write on the file, it takes a few hours to be effective.

Any ideas?

0
 
Jay_Jay70Commented:
hmm none at all!
0
 
frukeusAuthor Commented:
Thanks...I'm going to award points despite not having a solution because it helped in identifying the problem.
The new problem is posted here: http://www.experts-exchange.com/Operating_Systems/Windows_Server_2003/Q_21860189.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now