The following list identifies five typical user types and job functions.
| Functional Category | Description |
|---|---|
| General users | Database end-users who only need to read the data or to run pre-existing queries or macros to generate reports. |
| Update users | Privileged users who perform general user functions and who also may need to insert, update, or delete data, and create new database objects. |
| Batch users | High-level users who typically perform batch-level functions, for example:
|
| Database programmers | Users who design and create queries, macros, stored procedures, and database objects, for use by the user community. Programmers may require administrator privileges within a development database, while needing only limited privileges in the main production database. |
| Assistant administrators | Administrative users who assist the principal administrator, user DBADMIN. Assistant administrative users may have most or all privileges granted to user DBADMIN, but have a much smaller permanent space allocation due to their limited ownership of objects. |
You can create additional user types, where necessary, to identify functional differences; however, the examples provided in this document are based on these user types.