Authentication and authorization
The following tables are used for the user authentication and authorization mechanism of MVE.
MASTER_ROLE
This table contains all the roles supported by MVE.
|
Field name |
Data type |
Description |
|---|---|---|
|
ID |
BIGINT |
The primary key. |
|
ROLE_NAME |
VARCHAR(255) |
The name of the role. |
USERS
This table lists all the internal user accounts of MVE.
|
Field name |
Data type |
Description |
|---|---|---|
|
ID |
BIGINT |
The primary key. |
|
USER_NAME |
VARCHAR(15) |
The user-supplied user name. |
|
USER_PASS |
VARCHAR(1024) |
The user-supplied password. |
|
ENABLED |
SMALLINT/ TINYINT* |
The flag indicating whether this account is enabled. |
|
NAME |
VARCHAR(255) |
The user’s full name. |
|
LAST_LOGIN |
TIMESTAMP |
The time stamp of the last login attempt. |
|
LOGIN_ATTEMPT |
BIGINT |
The current number of attempts made at a successful login. |
|
REFRESH_TOKEN |
VARCHAR(1024) |
The authentication token when the user logs in. |
*This data type is required for Microsoft SQL Server.
USER_ROLE
This table describes the association of users to roles.
|
Field name |
Data type |
Description |
|---|---|---|
|
ID |
BIGINT |
The primary key. |
|
USER_NAME |
VARCHAR(15) |
The foreign key back to USERS.USER_NAME. |
|
ROLE_NAME |
VARCHAR(30) |
The foreign key back to MASTER_ROLE.ROLE_NAME. |