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

Posted on 2011-10-30
Last Modified: 2013-11-05
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?
Question by:inteliarchs
    LVL 5

    Expert Comment

    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.


    Dani Authorization Schema
    LVL 50

    Expert Comment

    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...

    Author Comment

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

    Accepted Solution

    If your problem is solved then please close this issue.



    Author Closing Comment

    Great job

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    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.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 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

    15 Experts available now in Live!

    Get 1:1 Help Now