Solved

Folder ACL List to Table

Posted on 2007-03-27
12
1,184 Views
Last Modified: 2013-11-27
Ultimately, this is what I want: I want to be able to print out a list of what folders a group or user has access to on a specific server and what permissions they have on that folder.

I'm thinking about dumping a list of users and groups into a table in MS Access and then doing some form of ACL query on a server and dumping that info into a table... the problem is, I don't know how to do that.

Anyone out there that can point me in the right direction or provide links?

FYI: Windows 2003 Domain
0
Comment
Question by:victornegri
  • 4
  • 3
  • 3
  • +1
12 Comments
 
LVL 67

Accepted Solution

by:
sirbounty earned 300 total points
ID: 18804765
http://www.somarsoft.com/ dumpacl may be helpful for you..
0
 
LVL 10

Author Comment

by:victornegri
ID: 18804884
Have that tool... but you know what, I never noticed that it had command line switches until now. I can probably just create csv files and link them in Access.

Thanks.

Will keep the question open just in case other people have input.
0
 
LVL 67

Expert Comment

by:sirbounty
ID: 18804947
SecurityExplorer (pricey) may be a more graphical option for you...
0
 

Expert Comment

by:pobblebonk
ID: 18805244
Hi,

I would recommend using a VBScript and WMI to query the servers and load the data into an access database using ADO.

If you need further advice let me know.

Mat
0
 
LVL 10

Author Comment

by:victornegri
ID: 18805750
Mat, If you could point me in the right direction for that I'd appreciate it. I tried doing that before but I couldn't get the recursion to work on large folder structures (which is what I need).
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 4

Assisted Solution

by:jmhquest
jmhquest earned 200 total points
ID: 18805909
You could create a PowerShell script to get a listing of all the folders and their ACLs on a server.

http://www.microsoft.com/technet/scriptcenter/hubs/msh.mspx
0
 
LVL 10

Author Comment

by:victornegri
ID: 18805916
Been looking into that too (just found it today). :)

Seems like it has good potential. Just hope I can call the script from within Access.

Do you have any good examples I can use to get started with PowerShell (for this particular project)?
0
 
LVL 4

Expert Comment

by:jmhquest
ID: 18807394
MS has an example to list all the folders on a computer.  Look in the PowerShell script repository.
0
 
LVL 4

Expert Comment

by:jmhquest
ID: 18807400
p.s. getting the ACLs is a WMI call.  Feed the results of the folder list into the wmi call.
0
 
LVL 67

Expert Comment

by:sirbounty
ID: 19009617
Nothing against {http:#18805244} but the author stated that they had already gotten that far on their own and the expert never returned to provide any further guidance on that route...
0
 
LVL 10

Author Comment

by:victornegri
ID: 19009795
I ended up using DumpACL in a batch file with link tables... but I'm learning how to use powershell so maybe in the future, that will be the solution.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Mapping Drives using Group policy preferences Are you still using old scripts to map your network drives if so this article will show you how to get away for old scripts and move toward Group Policy Preference for mapping them. First things f…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

705 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

20 Experts available now in Live!

Get 1:1 Help Now