By looking at the other posts, I think that some are confusing Primary Keys, which should only be used for referential integrity and not used by humans, and Reference Keys,...

Here is part of what I do...

CREATE VIEW [dbo].[DataDictonary] AS

SELECT schemas.name AS SchemaName

,all_objects.name AS TableName

,syscolumns.id AS ColumnId

,syscolumns.name ...

Here is a view that I add to my databases that I use to create a column level data dictionary. I think I will incorporate the ideas from this article...

If you want to see an interesting use of one time passwords check out GoToMyPC

From there documentation:

One-Time Passwords

The use of One-Time Passwords (OTPs) offers an additional level of security

that can...

This could be done by adding two columns to your user table. They are:

LoginCount int null

AllowedLoginCount int null

If AllowedLoginCount is greater then zero, this is how many time they can...