• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

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

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?
0
inteliarchs
Asked:
inteliarchs
  • 2
  • 2
1 Solution
 
mcs0506Commented:
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 Schema
0
 
LowfatspreadCommented:
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...
0
 
inteliarchsAuthor Commented:
Thank you this is what I came up with, I appreciate your response and so quickly.
0
 
mcs0506Commented:
Hi,
If your problem is solved then please close this issue.


Thanks


Dani
0
 
inteliarchsAuthor Commented:
Great job
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now