Giter Site home page Giter Site logo

frankiechapson / rights Goto Github PK

View Code? Open in Web Editor NEW
1.0 2.0 0.0 21 KB

How to manage users/user groups and their rights to the menus/functions

License: GNU General Public License v3.0

PLSQL 100.00%
sql plsql user-management rights authorization oracle

rights's Introduction

User rights

How to manage users/user groups and their rights to the menus/functions

Almost every application has an authorization system.

Here is my abstract implementation of this issue:

  • There is structure of functions and menu items of an application.
  • There is another structure of users and their user groups.
  • There are some connection between nodes of these two structure:

Figure:

APPL 1                <---------------------- A -------------------->       ADMINS
   |                                                                           |
   +-- HR MODUL       <-----------------------+                                +-- SA
   |    |                                     |                                |
   |    +-- HR MENU 1                         |                                +-- FERI
   |    |       |                             |                                    
   |    |       +-- HR FUNC 1                 E                                    
   |    |                                     |                            READERS   
   |    +-- HR MENU 2                         |                                |
   |            |                             |                                +-- JOHN
   |            +-- HR FUNC 2                 |                                |
   |                                          +--------------------->          +-- HR
   |                                                                           |    |
   +-- IT MODUL       <-----------------------+                                |    |
   |    |                                     |                                |    +-- MARY
   |    +-- IT MENU 1                         E                                |
   |    |       |                             |                                |
   |    |       |                             +--------------------->          +-- IT   
   |    |       +-- IT FUNC 1    <----+                                             |
   |    |                             |                                             +-- FRANK
   |    +-- IT MENU 2                 +--------- E ----------------->       HENRY              
   |            |                                                    
   |            +-- IT FUNC 2                                                  ^
   |                                                                           |
   +-- ZZ MODUL                                                                |
   |    |                                                                      |
   |    +-- ZZ MENU 1                                                          |
   |    |       |                                                               
   |    |       +-- ZZ FUNC 1                                                  E
   |    |                                                                       
   |    +-- ZZ MENU 2                                                          |
   |            |                                                              |
   |            +-- ZZ FUNC 2                                                  |
   |                                                                           |
   +-- FUNC 00       <---------------------------------------------------------+

The rules of the authorization system:

  • if a user can access a function (node), then she/he have to access every parents of this function too
  • if a user can access a menu point (node), then she/he can access every children of this menu point too

The functions of the authorization system:

  • who and how can access a menu point/function (node)?
  • which menu point/function and how is reachable for a user/user group?
  • is reachable a certain menu point/function for a certain user/user group?

rights's People

Contributors

frankiechapson avatar

Stargazers

 avatar

Watchers

 avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.