Cisco Cisco IP Contact Center Release 4.6.1 Technical References
2-288
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2 Table Details
User_Security_Control Table
User_Security_Control Table
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.
table from the data in the other security tables.
Related tables:
Ids (via ObjectType and ObjectID)
User Group Member (via UserName)
User_Supervisor_Map Table
Used to allow an agent to log in as a Supervisor. When an agent logs in as a Supervisor, an entry for the
agent is created in the User Group table to allow the agent login.
agent is created in the User Group table to allow the agent login.
Related tables:
User Group (via UserGroupID)
Table 2-192 User_Security_Control Table
Field Name
Description
Data Type
Keys and Null
Option
Option
ObjectType
Together with ObjectID, identifies the object.
int
PK, FK, NOT
NULL
NULL
ObjectID
Together with ObjectType, identifies the object.
int
PK, NOT NULL
UserName
The SQL Server username of the user.
varchar(30)
PK, IE1, NOT
NULL
NULL
AccessLevel
The level of access that the user has for the object:
10 = Read
20 = Reference
30 = Maintenance (create/read/update/delete)
20 = Reference
30 = Maintenance (create/read/update/delete)
int
NOT NULL
UserGroupID
Foreign key from the User_Group table.
int
IE2, NOT NULL
Table 2-193 User_Supervisor_Map Table
Field Name
Description
Data Type
Keys and Null
Option
Option
UserGroupID
The identifier for the user.
Note
The UserGroupType for this user must be U.
int
FK, NOT NULL
AgentSkillTargetID
The identifier for the SkillTargetID for an agent that is a
supervisor.
supervisor.
Note
The SupervisorAgent field for this agent must be Y.
int
AK1, NOT
NULL
NULL