Intranet site with Windows Authentication
Originally, our requirements were having us implement forms authentication. Our supporting database had "CreatedBy" and "UpdateById" columns on certain tables where we were tracking who created and updated records. Simply grabbing the Id of the user logged
in and inserting/update the row with the value.
Then we changed....
Now we are using windows authentication. Simple for the user; now they don't have to log in. A few questions have come up since we made this change and I haven't been able to locate other examples online.
First, should we store the username instead of an id? This would require changing all the column datatypes to string. Not a huge deal, just some overhead work. We aren't guaranteed uniqueness and there is the possibility that a user changes their username
so I can see that being an issue.
Second, is there a way to u ...
Go to the complete details ...