Solved

Storing and Retrieving Permissions in SQL Server

Posted on 2007-03-30
2
217 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Name Space error VS2015 1 37
Reactjs with .NET 3 78
Looking for a link to download the latest .NET redistribution package 5 33
How can I use this function? 3 34
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

726 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