tags:

views:

28

answers:

0
Q: 

spring 3 security schema username as primary key?

I Googled for this, but I couldn't find an answer anywhere. Why does the Spring 3 Security schema (http://static.springsource.org/spring-security/site/docs/3.1.x/reference/appendix-schema.html) have a username as a primary key instead of an integer guid?

People often suggest that using "natural" usernames as your pk is bad practice.

related questions

Number VS Varchar(2) Primary Keys
numeric(38,0) as primary key column; good, bad, who cares?
Change each record in a table with no primary key?
Reasons not to use an auto-incrementing number for a primary key
What happens when DB engine runs out of numbers to use for primary keys?
Do numerical primary keys of deleted records in a database get reused for future new records?
make an ID in a mysql table auto_increment (after the fact)
How to reset postgres' primary key sequence when it falls out of sync?
renumber primary key
Will SQL Server 2005 penalize me for using an nvarchar(50) as a primary key, instead of an integer?
How do I determine if a column is in the primary key of its table? (SQL Server)
Pros and cons of using md5 hash of URI as the primary key in a database
ORM support for compound primary keys
Can I have multiple primary keys in a single table?
Skipping primary key conflicts with SQL copy
Two foreign keys instead of primary
Huge (20 digits) Primary keys and SQLite
@@IDENTITY after INSERT statement always returns 0
Get the Primary Key of a new Entry
What is the proper size for a sequence-generated primary key?
What are the performance improvement of Sequential Guid over standard Guid?
Double-click double-insert resolutions?
Should I have a dedicated primary key field?
Easy mysql question regarding primary keys and an insert
Surrogate vs. natural/business keys