Cisco Cisco IPCC Web Option Technical References
2-428
Cisco ICM/IP Contact Center Enterprise Edition Database Schema Handbook, Release 6.0(0)
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:
(via ObjectType and ObjectID)
(via UserName)
Table 2-391 User_Security_Control Table Constraints
Constraint
Field Name(s)
PK
ObjectID
ObjectType
UserName
ObjectType
UserName
FK
ObjectType
IE-1
UserName
IE-2
UserGroupID
Table 2-392 User_Security_Control Table
Field Name
Description
Data Type
Keys and
Null Option
Null Option
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)
DBINT
NOT NULL
ObjectID
Together with ObjectType, identifies the object.
DBINT
PK
NOT NULL
ObjectType
Together with ObjectID, identifies the object.
DBINT
PK, FK
NOT NULL
UserGroupID
Foreign key from the User_Group table.
DBINT
IE-2
NOT NULL
UserName
The SQL Server username of the user.
varchar(30)
PK, IE-1
NOT NULL