Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Set folder permissions

Set folder permissions

Set folder permissions

I need to find a way to set NTFS permissions on folders

Here is what I have
There is a root folder named departments; and underneath that folder are all the department folders. HR,IT,Finance etc

I want to set top level folder permissions for each department. Example: HR group would have Full control on the HR folder and the IT group would have permission on the IT folder.

There are 42 departments and we are restoring from a snap server with a Linux OS to a Windows 2003 server so the permission won’t be retained from Linux when restored to the new server

Is there a way to use excel to assign the permission?

I have all my groups in an excel spreadsheet


RE: Set folder permissions

You could write a .VBS that would read your excel file, loop through the names, & run a cacls.exe to assign NTFS rights for each group to each folder.  Are the folder & groups names identical & do any of them have any spaces?

RE: Set folder permissions

Hi Jerz

The folders and groups are different

The Finace folder is called Finance with a security group called FI

Some of the folders are named like Information_Technology with a security group of IT


RE: Set folder permissions

well sounds like you will have to maintain a list of folders and what the permissions should be?

what we did was to setup the folders and permissions how they should be, then run an audit script to audit all folder permissions. the audit script produced a log file. we then wrote a restore script which runs against the log file to reset the permissions if needed.

we did all this during a server farm migration to a netfiler

RE: Set folder permissions

You could use xcacls.exe (downloadable) and build your command lines in Excel using the CONCATENATE function to produce lines like this:


xcacls.vbs \\server\sharename\userID/g domain\userID:m Domain\"Domain Admins":f /f /s /t

This removes existing permissions (g) then recursively assigns the modify permission to the user (:m)and full(:F) to members of the Domain Admins group.

Cut and paste your Excel cells into a batch file and you're good to go.

Not vb I know but hey, it works.  Also, if you set lookups in your spreadsheet to OUs etc, you can have the details all automatically filled in for you all you need to do is put the userID in a cell.



Network Admin
Hilliard Schools

RE: Set folder permissions

Thanks it sound like using excel is the only way to ge the job done


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close