Project for developing profil management

Purpose	Managing user profils. First with logins + passwords and access rights different for each tables. The system must be open for adding easily new profil information.
Estimated time	A lot
Melba classes to understand (estimated number)	server-side: 5 classes transfert: 25 classes client-side: 10 classes
Technologies to use	Java: JAXP, Servlets, Jdbc - Other: XML, SQL

Proposed solution

Intro

The profil information for a user will be stored in a XML element. All XML elements will be stored:

in a CLOB column, into a reserved table of the user database
or into an XML file

As prefer the dev-user.

The XML element: userProfil

It will be like this:

  <userProfil>
    <login>chocolat</login>
    <password>70%</password>
    <groupSet><groupRef group='default' /></groupSet>
    <accessRights>
      <tableAccess rights='sudi'>Profession;</tableAccess>
    </accessRights>
  </userProfil>

Here we have a user 'chocolat' with password '70%', who is a member of the group 'default'. He has specific access rights on the table 'Profession' for Select, Update, Delete, Insert. Note that the XML document isn't complete: an element 'group' has to be defined.

The SQL reserved table for storing user profil elements

It will be created by a script like this:

  CREATE TABLE USER_PROFIL (
    user_profil_id integer not null primary key,
    login varchar(255) not null unique,
    xml_element clob
  );

So, when a profil is researched from a login, the XML element <userProfil> is found with a simple query (example with the user 'chocolat'):

  select xml_element from USER_PROFIL where login='chocolat'

Do you want to help us ?

For any suggestions, please send an email here.

Tasks for this sub-project are available at the [Melba] profil sub-project.

Top