Scaffolding

[eluser]esra[/eluser]
If your status column was a foreign id to another table called roles, you could use yet another table to associate permissions with roles. Then you need to develop methods to conditionally grant or invoke permissions.

For some ideas, look here:

http://www.sqlrecipes.com/database_desig..._system-3/