Solved

Storing and Retrieving Permissions in SQL Server

Posted on 2007-03-30
2
223 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Learn by Doing. Anytime. Anywhere.

Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.

Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.

Question has a verified solution.

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

Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

729 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