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:
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=:USERID and PASSWORD=:PASSWORD
|