Technical References

User_Group_Member Table
This table is in the Security category (page 455). To see database rules for these tables, click
here (page 510).
Lists the specific users that are members of each user group. If the group is of type “U then it
has a single User_Group_Member record. If the group is of type 'G' is can have multiple
User_Group_Member records. A single user can be a member of multiple user groups.
Use Configuration Manager to create, update, and delete User Group Member records.
Related table
User Group (page 427) (via UserGroupID)
Table 212: Indexes for User_Group_Member Table
index_keysindex_descriptionindex_name
UserName, UserGroupNameclustered, unique, unique key
located on PRIMARY
XAK1User_Group_Member
UserNamenonclustered located on PRIMARYXIE1User_Group_Member
UserGroupMemberIDnonclustered, unique, primary key
located on PRIMARY
XPKUser_Group_Member
Fields in User_Group_Member Table:
Keys and Null Option:Data Type:Description:Field Name:
NOT NULLCHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
PK NOT NULLDBINT
A unique identifier for the record.
UserGroupMemberID
AK-1 NOT NULLvarchar(64)
The group to which the member belongs.
UserGroupName
AK-1, IE-1 NOT NULLvarchar(64)
The username as registered with SQL Server.
UserName
User_Security_Control Table
This table is in the Security category (page 455). To see database rules for these tables, click
here (page 510).
Specifies the security access that individual users have to specific objects. The ICM software
builds this table from the data in the other security tables.
Related tables
Ids (page 216) (via ObjectType + ObjectID)
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
429
Chapter 2: All Tables
User_Group_Member Table