Click here to get back home

security on 2 databases - 1 inside web folder, 1outside - why diff

 HomeNewsGroups | Search | About
 microsoft.public.windows.server.security    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
security on 2 databases - 1 inside web folder, 1outside - why diff Jonathan 06-02-2005
Posted by Jonathan on June 2, 2005, 6:12 am
Please log in for more thread options
Still learning a lot about security but this one issue has been driving me
nuts. I have a database on our web server that located in a folder under the
wwwroot directory (ie its part of the website). I have another one that is
located outside of the web direcectory in a seperate folder.

I have a scripts that run that update either database. Now the NTFS
security on the the database located in the web folders requires the IUSR_*
account to have the read, write, execute, etc. access so that the scripts can
update the database correctly.

Yet the NTFS security on the database that is located outside of the web
site doesn't need any of that security and it works fine.

Example: C:\inetput\wwwroot\fpdb\data1.mdb has to have access set for IUSR_*
then C:\databases\data2.mdb doesn't.

data2.mdb only has Admin, System and Users (where users only has NT
authenticated users in it)

Yet if I make the security on data1.mdb an exact mirror of the security on
data2.mdb then none of the ASP scripts will work on data1.mdb.

So my question is why? Why does one need to have the IUSR_* account to be
able to update but the other doesn't? I can make everything identicial (both
the NFTS file and folder permissions and the settings through IIS 6.0) but it
doesn't change.

My only guess is that its because one is inside the website and the other is
not - but wanted to know if this is true and why. Any info would be great -
its nothing ciritcal - I just hate not understanding this behavoir and have
no idea how to even begin searching for an answer to this.

Thanks,
Jonathan Adams


Similar ThreadsPosted
Security Diff. W2000, W2003 March 22, 2006, 11:09 am
Inside Runas /netonly February 6, 2006, 9:31 pm
automate xcopy btw Win servers with diff domain memberships ? January 12, 2006, 2:25 pm
How to set this Folder security October 5, 2006, 8:25 pm
Folder Security November 17, 2006, 6:34 am
Folder redirection and security November 9, 2005, 10:45 am
Folder security question February 10, 2006, 11:58 am
Folder security problem April 6, 2006, 1:27 am
Security on Tasks Folder April 24, 2006, 11:23 am
Folder and Files Security October 3, 2006, 1:46 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap