The following table describes the minimal privileges required by the three basic user types.
| User Type | Privilege Requirements |
|---|---|
| General | Database end-users who typically read data and execute macros in a read-only Views database. Assign the following privileges on a read-only Views database to all General users:
The read-only Views database must have privileges on the Tables_Database, as shown in Working with Table Access Privileges for Views. |
| Update | Privileged database users who update data generally require the following privileges: Privileges required on a read-only Views database:
Privileges required on an updatable Views database:
Additional recommended privileges on an updatable Views database for database programmers:
To provide update capability on views, you must grant the updatable Views database SELECT, INSERT, UPDATE, DELETE WITH GRANT OPTION privileges on the referenced tables in the Tables_Database, as shown in Working with Table Access Privileges for Views. |
| Batch | Data movers, who typically perform batch-level functions, such as:
Batch users must have the following privileges on the Tables_Database:
|
| Assistant Administrators | If you need one or more assistant administrators to help share administrative duties, they may require the same privileges as those granted to DBADMIN, or a subset of those privileges. Use the procedure shown in Setting Up the Database Administrator User to create assistant administrators and grant the privileges they need. |
| Database Programmers | Database programmers may require administrator-level privileges within the development database to allow them to create and test database objects. Administrators can then deploy the objects to the production database. |