<div>
Hi,<br />
you have to create some tables regarding authorization e.g following are the tables:<br />
<br />
Users (contains User Information)<br />
Groups (contains Group Names)<br />
UserGroup (Contains association of user and group)<br />
FunctionalityObjects &nbsp;(Contains names of all functionalities )<br />
GroupPermission &nbsp;(Contains association of functionality with of that group that actually have permission for specific functionalityId)<br />
<br />
db schema image is also attached.<br />
<br />
Regards,<br />
<br />
Dani <a href="https://filedb.experts-exchange.com/incoming/2011/10_w45/518166/dbSchema.JPG" target="_blank" title="Authorization Schema (30 KB)"><img alt="Authorization Schema" class="file-block lazyload" style="max-width: 763px;" data-src="https://filedb.experts-exchange.com/incoming/2011/10_w45/518166/dbSchema.JPG" /></a>
</div>


Hi,
you have to create some tables regarding authorization e.g following are the tables:

Users (contains User Information)
Groups (contains Group Names)
UserGroup (Contains association of user and group)
FunctionalityObjects  (Contains names of all functionalities )
GroupPermission  (Contains association of functionality with of that group that actually have permission for specific functionalityId)

db schema image is also attached.

Regards,

Dani Authorization Schemahttps://filedb.experts-exchange.com/incoming/2011/10_w45/518166/dbSchema.JPG

dbSchema.JPG

<div>
you may also need a userfunctionality object if there are limits within the functions...<br />
<br />
e.g. an individual may have cheque signing authority but only up to a certain monetary limit...<br />
<br />
so they are part of the cheque signers/authorisors groups but only for certain limits...
</div>


you may also need a userfunctionality object if there are limits within the functions...

e.g. an individual may have cheque signing authority but only up to a certain monetary limit...

so they are part of the cheque signers/authorisors groups but only for certain limits...

<div>
Thank you this is what I came up with, I appreciate your response and so quickly. 
</div>


Thank you this is what I came up with, I appreciate your response and so quickly.

<div>
<div class="content wysiwyg-content">
 My application will have 20 pieces of functionality that I want to grant individually. &nbsp;To simplify the application, I want to assign users to 1 or more of 5 groups which will be associated to the pieces of functionality. &nbsp;How would you draw the need table or tables? 
</div>
</div>


 My application will have 20 pieces of functionality that I want to grant individually.  To simplify the application, I want to assign users to 1 or more of 5 groups which will be associated to the pieces of functionality.  How would you draw the need table or tables? 

I need a database to store authorization information for an application.

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.