October 18, 2005 at 4:42 am
Calling all SQL Guru's
I need to find out a list of people that have access to a particular file in a share. The purpose of this is to update my records and whoever has access to this particular folder will give me all the users names I require. Is there a Stored Procedure that can do this? or is there another route I can go down? I am exceptionally new to SQL Server, but would like to help myself before I ask my Networks team.
Thank You in advance for any help you can give me!!!
October 18, 2005 at 5:31 am
Unless you have this information stored inside SQL (out of the box it isn't there) you won't be able to find it. HOWEVER, I am sure that someone can help post something about using xp_cmdshell to call external functions to go to that folder and pull the security up.
You may also want to check out filesystemobject on-line to see if that can provide security information as well....
Good Hunting!
AJ Ahrens
webmaster@kritter.net
October 22, 2005 at 9:36 am
"WMI" is the way to go.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply