Solved

How do you grant rights to a file

Posted on 2012-12-27
7
272 Views
Last Modified: 2012-12-29
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).
0
Comment
Question by:Harper-IT
7 Comments
 
LVL 23

Expert Comment

by:Thomas Grassi
ID: 38723808
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.
0
 
LVL 70

Expert Comment

by:KCTS
ID: 38723828
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)
0
 
LVL 54

Expert Comment

by:McKnife
ID: 38723831
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.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 4

Expert Comment

by:palicos
ID: 38726492
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.
0
 
LVL 70

Accepted Solution

by:
KCTS earned 500 total points
ID: 38726542
If you give full control to 'Everyone' then you've just blown all your security away.

If you want to share files - then do it properly - create folders - put the files in the folders and set the NTFS and share permissions accordingly - by all means set the share permissions on the share to 'Everyone' and use NTFS permissions to tie down the security - but don't share your own private documents.
0
 
LVL 1

Author Closing Comment

by:Harper-IT
ID: 38726937
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!
0
 
LVL 4

Expert Comment

by:palicos
ID: 38729651
No issues what we can help so we tried our level best...
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Introduction You may have a need to setup a group of users to allow local administrative access on workstations.  In a domain environment this can easily be achieved with Restricted Groups and Group Policies. This article will demonstrate how to…
Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

815 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now