The following list identifies five typical user types and job functions.
|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 who assist the principal administrator, user DBADMIN. Assistant administrative users may have most or all of the same privileges granted to user DBADMIN, 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 document are based on these user types.