Hello,

I looking into adding permissions into one of my programs. I am looking for the best way to store these in a SQL database. My inital thought is columns define the permissions (EX: AddUsers(BIT)) but that kind of limits the database if I add more functionality and it needs a setting to define the permissions for access to it.

What would be a good way to go about the database design and incorporate it into the database?