Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 12 Users and Work Queues : user_memb

user_memb
The user_memb table defines users’ membership of groups.
Structure
The user_memb table has the following structure:
TABLE user_memb (
node_id INTEGER NOT NULL,
user_id INTEGER NOT NULL,
group_id INTEGER NOT NULL)
Primary Key
The following primary key is defined for this table.
Triggers
None.
Indexes
The following index is defined for this table.
Table Activity
The user_memb table contains one row for every user/group member relationship defined on the system. For example, if a user is a member of three different groups, there are three rows for that user in this table.
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