Stupid Question? SQL Server DSN - NT Authentication - Network ID Change?
We have a VB Appln running in client machines.
DSN's are set to Windows NT authentication.
But is SQL Server, Mangers (Supervisors) are given DELETE permission. So they can delete a record.
The problem here is the supervisor can only delete a record thro VB application only if he logins Windows. We need him to delete the record by logging on to just VB application (Not Windows Login) on the client machine.
How do you do that? That is changing the Windows login ID thro appln or If question looks really absurd pls suggest any other way to DELETE from client machine.
