Mapping UsersTable of ContentsMap Single
Mapping Users to Different NT Accounts

Mapping each user to different Windows NT account

To have the possibility of mapping each userid and password submitted by the internet browser to different Windows NT accounts, you need to have a database that stores these mappings.

The structure of your user mappings table for this scenario would look like this MS Access table:

Sample Database Table

Once you have such a user table, your SQL Statement that you can use with bcAuthenticate could be:

where USERID=

This way, when for example, johnj logs in to the webserver, he will only be able to see resources that are permitted for PROJECT1_CUST Windows NT account. He will not be able to see the resources of PROJECT2_CUST when permissions are granted accordingly. Setting up directory access permissions in Windows NT.