Cisco Cisco IP Contact Center Release 4.6.1 Technical References

User_Group_Member Table

This table is in the 

. To see database rules for these tables, click

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.

 (via UserGroupID)

UserName, UserGroupName

clustered, unique, unique key
located on PRIMARY

XAK1User_Group_Member

UserName

nonclustered located on PRIMARY

XIE1User_Group_Member

UserGroupMemberID

nonclustered, unique, primary key
located on PRIMARY

XPKUser_Group_Member

NOT NULL

CHANGESTAMP

Incremented when the record is changed in the central database.

ChangeStamp

PK NOT NULL

DBINT

A unique identifier for the record.

UserGroupMemberID

AK-1 NOT NULL

varchar(64)

The group to which the member belongs.

UserGroupName

AK-1, IE-1 NOT NULL

varchar(64)

The username as registered with SQL Server.

UserName

User_Security_Control Table

This table is in the 

. To see database rules for these tables, click

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.

 (via ObjectType + ObjectID)

Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)