The FLG.USERS table contains a list of all the information catalog administrators and users with special administrative privileges. Unlike most of the other Information Catalog Manager store tables, the FLG.USERS table does not contain metadata. It contains definitions of different types of information catalog users and their status.
The USERTYPE and DGUSER columns form the primary key of the table.
The DGUSER column is an index of the table.
Table 73 provides information about each column found in the
FLG.USERS table.
Table 73. FLG.USERS table column properties
| Column name | Data type | Description | Nullable | NLS |
|---|---|---|---|---|
| DGUSER | CHAR(8) | The user ID of the information catalog administrator. The ID is entered at installation. | No | Both SBCS and DBCS |
| USERTYPE | CHAR(1) | Type of DGUSER. The type can be an information catalog
administrator, a user with special update privileges, or a user.
This value is set during installation. | No | SBCS |
| ACTIVEKA | CHAR(1) | A flag to indicate the information catalog administrator who is currently logged on to the Information Catalog Manager. Only one information catalog administrator can be logged on at a time. | Yes | SBCS |
| Note:
NLS: National Language Support SBCS: Single Byte Character Set DBCS: Double Byte Character Set | ||||