Solved

Storing and Retrieving Permissions in SQL Server

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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

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 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.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now