Avatar of Harper-IT
Harper-IT
Flag for United States of America asked on

How do you grant rights to a file

I need to grant a user rights to an Excel file.  The problem is the file is in a "private" folder, and the user doesn't have access to the folder.

I have gone to the file level and granted him all rights except for Full Control and Special permissions.  I then created a shortcut that points directly to this file and moved it to the user's desktop.  The user clicks on the shortcut and is able to open, read and modify the file.  The problem is, when the user tries to save the file he gets the following message:  "Access Denied.  Contact you administrator."

Obviously, I am missing something.  The owner of the file doesn't want to move the file because of the sensitivity of the information inside those files.  And I was also told that he would like to be able to do this with a couple more users (except they would have access to a different file).

Does anyone have a suggestion?  These files are on the network (Windows Server 2003 R2).
Active Directory

Avatar of undefined
Last Comment
palicos

8/22/2022 - Mon
Member_2_6492660_1

create a group in Active Directory place all the users in that group.
Give  that group the rights needed for accessing the folder.

Need to share the folder

The folder can be shared an no one but the group can have access to this folder.

NTFS and Share permissions need to be set.
Brian Pierce

Its going to get very messy if you don't do it properly - the 'proper' way would be to create a new folder for each user (or group of users), assign the NTFS and share permissions on that folder and then put the file(s) in the appropriate folder(s)
McKnife

Hi.

If you don't want to move that file to a separate folder, you will need to grant access rights to the folder, too - that should be obvious. Simply share that folder and grant read access to that folder on both NTFS and share permissions and don't let the files inherit these permissions - that way, he will only be able to browse that folder but not read the other files' contents.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
palicos

You will need to give full control to "Everyone" group on the machine. Found this post on MSDN which talks about it.

http://social.msdn.microsoft.com/Forums/en-SG/windowssdk/thread/de213b61-dc7e-4f33-acdb-893aa96837fa

Moreover refer this link also

http://technet.microsoft.com/en-us/library/bb727008.aspx

Hope this works for you.
ASKER CERTIFIED SOLUTION
Brian Pierce

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Harper-IT

ASKER
I want to thank you all for the feedback.  Before all of this, I tried explaining to my boss the headache involved by not moving a file, keeping it in a private (secure) folder and granting rights so that only a particular user can get to it.  It wasn't until he was made aware of all or your comments, that a light went on.

I have been given permission to move the file(s) to a "public" sub folder in his "private" folder.  Thanks again for all the feedback!
palicos

No issues what we can help so we tried our level best...
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.