Solved

Storing and Retrieving Permissions in SQL Server

Posted on 2007-03-30
2
203 Views
Last Modified: 2013-11-26
Hi all,
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.
0
Comment
Question by:ericlockshine
2 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 250 total points
ID: 18825082
You can use an integer column.  This will allow up to 32 true/false settings.  If you need more than that consider a bigint, sthis will support up to 64 true/false settings.
0
 

Author Comment

by:ericlockshine
ID: 18825845
Thanks for the idea!
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question