Hi
My ASP based website relies heavily on an MS Access database to display it's content. The database is outside the root directory of my site, so it cannot be accessed via the web, and a System DSN has been set up on the server.
This worked fine, until the security of my database became an issue. Other users of the server could call up a list of the available DSN's on the server quite easily, and access my database, so i had it arranged that the odbc.ini file was blocked. Now people cannot see a list of the DSN's but they can still guess it to gain access.
So i put a password on the database, and that stops people from getting to the database through the DSN
The problem i face is that i have to give the database folder full permissions in order for my webpage to function properly (i was getting 80004005 errors before i changed permissions). Which is quite annoying really, in order to protect my data i have to give the anonymouse user more rights..
I was wondering if anyone could advise me to the security issues i now face. To my understanding my database is secure from people trying to access it through the DSN, but what are the implications of giving the directory full rights? How easy would it be for someone to wreak havok
thanx in advance.