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 some 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, and stored procedures, as well as 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 that assist the principal administrator, user DBADM. Assistant administrative users may have most or all of the same privileges granted to user DBADM, but have a much smaller permanent space allocation because they have a limited ownership of objects. |
You can create additional user types where necessary to identify functional differences, however, the examples provided in this book are based on these user types.