Storing and Retrieving Permissions in SQL Server
Posted on 2007-03-30
I have a set of permissions that I want to store in a database. They are all either true or false. I currently have around 20 or so that I want to store into 1 field that will later be retrieved into a program.
What is the best way to do this?
2 things I need to be able to do:
Store into 1 field in a database
Be able to add permissions.
There will be a follow up question on how to program in ASP.NET the storage into and retrieval from this database fields into some kind of variable.