<div>
Thanks for the idea!<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi all,<br />
I have a set of permissions that I want to store in a database. &nbsp;They are all either true or false. &nbsp;I currently have around 20 or so that I want to store into 1 field that will later be retrieved into a program.<br />
<br />
&nbsp;What is the best way to do this?<br />
<br />
2 things I need to be able to do:<br />
Store into 1 field in a database<br />
Be able to add permissions.<br />
<br />
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.
</div>
</div>


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.

Storing and Retrieving Permissions in SQL Server

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.