User groups

User groups are groups of users with access to the database.

The name of a user group generally has the following structure (for more information see table 18 of a section "Checking access rights"):

   host + appl + grp

host appl grp

Name of the host computer Name of the UDS/SQL/openUTM application or “_“ BS2000 identification or, in the case of a UDS/SQL-openUTM application, the KSET name associated with the openUTM user ID.

UDS/SQL uses underscores “_“ internally to pad each of the three components to eight characters.

openUTM or UDS/SQL ascertains the information required. Further entries on access rights are therefore generally not required in the application programs (e.g. PRIVACY-RECORD in the SUB-SCHEMA SECTION, PERMIT in SQL programs). UDS/SQL ignores specifications in existing programs.

Before a user group can execute database calls, you must define a name for it and assign it access rights with ONLINE-PRIVACY or with BPRIVACY.

You will find further information in the "Database Operation" manual, which also contains an example of how to define UDS/SQL user groups and assign access rights.