Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 12 Users and Work Queues : user_names

user_names
The user_names table holds the names of all iProcess user and group queues registered on the system.
Structure
The user_names table has the following structure:
TABLE user_names (
node_id
INTEGER NOT NULL,
user_id INTEGER NOT NULL,
user_name VARCHAR(64) NOT NULL,
user_type VARCHAR(1) NOT NULL)
Note: Users and groups have separate ID sequences, as defined in the user_type column, so both a user and a group can have the same user_id value.
Queue type: user (U) or group (G).
Primary Key
The following primary key is defined for this table.
Triggers
The following DELETE CASCADE triggers are defined for this table.
Indexes
The following indexes are defined for this table.
Table Activity
The user_names table contains one row for each user or group queue defined on the system.
Rows are added, updated and deleted in the following situations.
a Move System Information is performed, if the flag_table indicates that the Users data area has been modified.
Note: The table is purged and rewritten using the values from the tsys_user_names table.
a Move System Information is performed, if the flag_table indicates that the Users data area has been modified.
Note: The table is purged and rewritten using the values from the tsys_user_names table.

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.