Re: .mdb used with IIS > security?

From: Jerome (jherr_at_no.mnhn.spam.lu)
Date: 03/18/04


Date: Thu, 18 Mar 2004 11:43:34 +0100

No, file permission in fact!

I can share the folder, that's not the problem.

But there a different db files in that folder and I don't want that ALL
the users that have access to the folder also have access to ALL the
files. I therefore want to use file permission, which wouldn't be a
problem if it weren't that some of these databases are also used in an
ASP web application. And I want to know which generic user (I though it
was INET_servername but that didn't work) is responsible for the 'ASP
permissions' so to speak. Because I need to add that generic user to
avoid the 'file is locked or doesn't have the permission to access'
error ...

Did that make it anymore clear?

br1an_g wrote:
> Hi Jerome,
>
> i take it you are talking about Folder permissions?
>
> I give everyone change access on folders that contain my
> databases. (NT 4.0)
>
> Brian
>
>
>>-----Original Message-----
>>Hello,
>>
>>I've got the following situation:
>>
>>1. There's an Microsoft Access mdb file in a directory on
>
> my webserver
>
>>(Windows 2000 server).
>>2. It's used on ASP pages via ODBC.
>>3. The directory it's in is locally shared so a user can
>
> enter data in it.
>
>>My question now is what kind of permissions can I set on
>
> the file so
>
>>that the file is only accessible in our internal network
>
> by special
>
>>users AND via the Internet/Intranet.
>>
>>I tried to remove the "Everyone" on the permissions and
>
> then only added
>
>>the specific users as well as the IUSR_servername with
>
> Modify rights.
>
>>But then I get en error on the ASP page saying the file
>
> is locked or the
>
>>internet user doesn't have the appropriate rights.
>>
>>So what local permissions are needed on the file so an
>
> internal user can
>
>>surf the ASP page and edit data via the browser?
>>
>>I hope anyone understands what I'm trying to say ;o)
>>
>>Anyhelp is greatly appreciatd,
>>
>>Jerome
>>.
>>



Relevant Pages

  • Re: Access97 DB locks up the asp code at times
    ... of these users created the query off the asp and that's the problem. ... but I could never see the employee.ldb on the folder ... I'll chat with our IT group about setting the proper permissions. ... All database users, including the IUSR_MachineName account, need ...
    (microsoft.public.inetserver.asp.general)
  • Re: Minimum NTFS Permissions - Theres such a thing???
    ... ?2001 Microsoft Corporation. ... HOW TO: Set Minimum NTFS Permissions Required for IIS 5.0 to Work WGID:198 ... " List Folder Contents" ...
    (microsoft.public.inetserver.iis.security)
  • Re: Unable to delete orphaned 1.5 GB System Restore folder
    ... The fact that the tech support is based in India has nothing to do with the ... If so you may want to leave this folder alone. ... down to all children folders because i can set those permissions to ... try deleting from the command line using system by using the AT ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Unable to delete orphaned 1.5 GB System Restore folder
    ... The only computers i fix are my own. ... If so you may want to leave this folder alone. ... it includes all subdirectories with inherited permissions. ... try deleting from the command line using system by using the AT ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Word mail merge data source
    ... "Peter Jamieson" wrote: ... Word on it) then there may be a problem if the folder containing the data ... Word builds a connection string. ... superset of other users' permissions - for example, ...
    (microsoft.public.word.vba.general)