ST_ROLE - Virtual system table defining possible role.

Possible values

valueDescription
rootAdministrator of the organisation. All rights granted.
presidentPresident of the organisation.
assistantAssistant of the organisation, usually assist the president.
accountManagerAccount manager of the organisation.
employeeEmployee of the organisation.
memberMember of the organisation, or member of a section.
sectionManagerManager of a section.
supervisorSupervisor of a section.

Roles, levels and rights

Each role defines a level. A level grant access to define on a higher level:

  • Change password
  • Assign role with an higher level

A role with level equals or higher than 1000 cannot log in the application.

Administrator

  • Level = 0
  • All rights granted

President

  • Level = 100

Assistant

  • Level = 200
  • Edit member basic information
  • View all sections information

Account Manager

  • Level = 200
  • Edit financial information
  • View all sections information

Section Manager

  • Level = 300
  • Edit its section information
  • Edit member basic information
  • View other sections information

Employee, Supervisor, Member

  • level = 1000

References

  • Member for role in the organisation
  • MES Link for role in a section for a given exercise