Home | Using Katmandoo | Quick Start Guide | How-to | Task Menu | Table of Contents | See Also | Collapse All

System Group

Overview

It is used in Katmandoo to group system users to grant permission on resources and genus.
There are two categories of permissions assigned to the System Groups
  1. Authorised System Resource
  2. Authorised Genus

Detail

Examples of System groups


These are examples of recommended system groups. It?s up to the DBA/client to define the system groups and the level of permission the system group needs to have.

System Group Name Sub-system Name What permission the group should have?
Wheat Agronomy Admins Wheat Agronomy The system group should have administrative access to perform ?DEAR? (DELETE, EDIT, ADD and READ) operation in all the Wheat resources only!
Wheat Agronomy GenotypeAdmins Wheat Agronomy The system group should have administrative access to perform ?DEAR? operation in the Genotype table for the Wheat genotypes only!
Wheat Agronomy Breeders Wheat Agronomy The system group should full (?DEAR? operation) access on ?Wheat Agronomy? sub-system except they will have read-only permission on Genotype table for the Wheat Genotype.
Wheat Agronomy TrialManagers Wheat Agronomy The system group should have complete (?EAR? operation) access on ?Wheat Agronomy? sub-system except they will have read-only permission on Genotype table for the Wheat Genotype.
Wheat Agronomy Biometricians Wheat Agronomy The system group should have Guest (ie read-only) access to all the tables but will have Owner (ie Edit which includes edit/add/read access) to the tables that are used to store AOV and MET data.
Wheat Agronomy Users Wheat Agronomy The system group should have Guest (read-only) access to all the Wheat resources.

Important Note: It is strongly recommended not to use a single system group to grant permission for all the System Resources of a Sub-system.

Table Structure

Column Name Description
SystemGroupId (PK) Identification Number that uniquely identifies a group of a sub-system (of a Genus) that will be granted permission to one or more System Resource. (PK)
SystemGroupName (AK) Name that uniquely identifies a group of a Sub-system (of a Genus) that will be granted permission to one or more System Resource. (REQUIRED)
SubSystemId (FK) Identification Number that identifies a Sub-system of a Genus (or crop) to which this group belongs.

Pre-requisite

The following information must exist before a System Group can be added into the database.

Main Form

Use [ Task > System > Manage System Group ] to load System Group Main Form with all the System Groups in the database.
Illustrative snapshot:
Main Form of System Group (Click it to change its size)
  1. System Group Main Form displaying all the System Group that are stored in the database.
    • Use [ View > Arrange columns in Main Form ] to change default order of displayed. Alternately it can be changed by editing the column list of the Misc Group SystemGroupSetupDataGrid.
    • Click here for an illustration of the main form template.
  2. Rescources with the granted role for the selected system group (ie Lupin Agronomy Users in the snapshot).
    • Click here for more information on Authorised Resource.
  3. Genus with the granted role for the selected system group (ie Lupin Agronomy Users in the snapshot).
    • Click here for more information on Authorised Genus.
  4. System users of the selected system group (ie Lupin Agronomy Users in the snapshot).
    • Click here for more information on Authorised System Group.

Setup Form

Important Note: Though a new System Group can be added by this form, it is strongly recommended to use Sub-system Setup which add default system groups for the new Sub-system.

To add/edit a System Group, follow the steps below :
Illustrative snapshot:
 Setup Form of System Group (Click it to change its size)
  1. System Group name and postcode are disabled since the System Group has dependant data. Click here for information on editing restricted value.
  2. Description of the System Group.
  3. Sub-system of the System Group. It can not be changed once the System Group is added.

See Also