JdbcAuthenticationManagerDataModel
Description
At a first look, jGuardīs data model would look a little hard to understand.
To make it a little bit easier to understand, here it goes a definition of the data structure used by jGuardīs Authentication (JDBC) module.
Tables and Fields
Tables
| Name | Description |
|---|
| jg_user | |
| jg_credential | Stores all Credential (information related to a specific user), like login, password, security id, born date, motherīs maiden name, etc. |
| jg_principal | Stores all the Principals (Userīs Roles and Userīs Responsibilities - itīs called Principal to keep compatibility with JAAS nomeclature). |
| jg_user_principal | Stores the relations regarding Users and Principals. An association means that the User has the Principal. As each Application has it owns Principals, if a User has a Principal named "Admin" in appA and also in appB, it must be associated with both Principals (even the name being the same the Principals are related to the Applicationīs display-name (web.xml tag). |
Table: jg_user
| Field Name | Description |
|---|
| id | the Userīs id. It will be used to make the link between the user and his credentials, also with his principals. |
Table: jg_credential
| Field Name | Description |
|---|
| id | the Credentialīs id. |
| user_id | The Userīs id wich owns this Credential. |
| public_visibility | Is this Credential visible to everyone or just to a Subject with proper access? |
| cred_name | The Credentialīs name. This field will identify the Credential. |
| cred_value | The Credentialīs value. This is the value of the Credential. |
Table: jg_principal
| Field Name | Description |
|---|
| id | the Principalīs id. |
| name | the Principalīs name. |
| application_name | the web.xmlīs display-name tag value of the application where this Principal exists. |
| class_name | until now, is net.sf.jguard.principals.JGuardPrincipal, wich is the full qualified name of the class that will be instantiated by jGuard to store this Principal. |
Table: jg_user_principal
| Field Name | Description |
|---|
| user_id | the Userīs id. |
| principal_id | the Principalīs id. |
ER Diagram
Comments: 0