ej_role table - SuperOffice

ej_role Table (323)

Define access rights, memberships and other properties for role user members

Fields

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
name	This is the name of the role	String(255)	Yes
use_user_group	Override user user group with role	Bool	Yes
user_group	The group this user is member of	FK hierarchy	No
access_mask	Access mask for users using this role	Int	Yes
access_values	Access values for users using this role	Int	Yes
use_categories	Override user categories with role categories	Bool	Yes

ej_role table relationship diagram

Indexes

Fields	Types	Description
user_group	FK	Index

Relationships

Table	Description
hierarchy	This table contains folders used to group the extra tables in the system.
role_category	Category membership associated with a role
role_element	Profiles associated with a role
role_member	Users linked to a role. Deprecated.
role_workflow	Knowledge base workflow access rights associated with a role

Replication Flags

None

Security Flags

No access control via user’s Role.