1. When installing the system, user name/password combinations are defined.
a) The CONTROLUSER
controls and monitors the system. He is responsible for backing up the database. For these tasks, the ADABAS component CONTROL has been provided.
b) The SYSDBA (system database administrator)
installs the system; i.e., his tasks include creating user accounts. The position of the SYSDBA within the hierarchy of user classes is described in 2d below.
c) The DOMAINUSER
maintains the system tables. His name is always DOMAIN. Any password can be chosen.
For the installation of the system, see the CONTROL manual.
2. There are four hierarchical classes of users in WARM database mode:
a) STANDARD users
can only access existing tables for which they have received privileges. For these tables, they can create synonyms and view tables.
b) RESOURCE users
have all the rights of a STANDARD user. In addition, they can create private tables and grant privileges for them.
c) Database administrators (DBA)
are responsible for the organization of the database system. The DBA has all the rights of a RESOURCE user. Database administrators can create RESOURCE users and STANDARD users.
d) The system database administrator (SYSDBA)
installs the system. The system database administrator has all the rights of a DBA. In addition, he can create users with DBA status.
In a non-distributed database, there is only one SYSDBA.
3. It is possible to create usergroups. All members of a usergroup have the same rights on the data that is assigned to the usergroup.
4. Users can only be defined in the SQLMODEs ADABAS and ORACLE; usergroups can only be defined in SQLMODE ADABAS.