Privileges determine what a user is authorized to do with the data and the database. Assign privileges based on the type of work the person does within the organization.
As an IBM Informix database administrator, you create groups based on what people need to do in the database, grant privileges to the groups, and add the appropriate users to each group. This topic lists the minimum required privileges for common types of users for which you would create groups: data viewers, data editors, and data creators.
Note that these privileges apply to using ArcGIS with an Informix database. If you need to know the privileges required to use a geodatabase in Informix, see Privileges for geodatabases in Informix.
If your users do more than view and issue simple SELECT statements, they need RESOURCE privileges in the Informix database. Resource-level privileges allow the user to do the following:
- Connect to the database.
- Execute SELECT, INSERT, UPDATE, and DELETE statements, provided the user has the necessary table-level privileges.
- Create views, provided the user has the SELECT privilege on the underlying tables.
- Create synonyms.
- Create temporary tables and indexes on them.
- Alter or drop a table or index, provided the user has the necessary table-level privileges.
- Grant table-level privileges.
- Create tables.
- Create indexes.
- Create routines.
- Create data types.
| Type of user | Required privileges | Purpose |
|---|---|---|
Data viewer | CONNECT | This privilege allows the user to connect to the database. |
SELECT on other users' tables | Data viewers need select privileges on specific tables you want them to see and query. | |
Data editor* Data editors require the same privileges as data viewers, plus these additional privileges. | RESOURCE | Allows user to execute SELECT, INSERT, UPDATE, and DELETE statements. |
INSERT, UPDATE, DELETE on other users' tables | Grant the editing operations you want editors to perform on specific tables. | |
Data creator | RESOURCE | Allows user to create tables and other database objects. |
*To edit data from ArcGIS, publish the data as a feature service that has editing capabilities enabled.