Copyright © Cloud Software Group, Inc. All rights reserved.
Copyright © Cloud Software Group, 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.
Foreign Keys
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 © Cloud Software Group, Inc. All rights reserved.
Copyright © Cloud Software Group, Inc. All rights reserved.