Map MultipleTable of ContentsNT Permissions
Mapping Users to the Same NT Account

Mapping each user to the same Windows NT account

Sometimes, you might have an existing database table that does not define mappings to Windows NT accounts but only hold user id and password informartion. In such case, for the sake of example, your MS Access table could look like this:

Sample Database Table

In this case, to map all these users to the same Windows NT account, you could write a query that looks like this:

select ‘PROJECT1_CUST’, ’yhoo357’ from USER2
where USERID=