Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 620
Keys and Null Option:
Data Type:
Description:
Field Name:
PK NOT NULL
DBINT
A unique identifier for the object type.
ObjectType
Object_Security Table
This table is in the 
To see database rules for these tables, click
Specifies the access level each user or group has to individual objects. The Primary Key (PK)
is nonclustered. The AlternateKey (AK) is clustered.
Related tables
 (via UserGroupName)
Table 136: Indexes for Object_Security Table
index_keys
index_description
index_name
UserGroupName, ObjectID, ObjectType
clustered, unique, unique key
located on PRIMARY
XAK1Object_Security
UserGroupName
nonclustered located on PRIMARY
XIE1Object_Security
ObjectSecurityID
nonclustered, unique, primary key
located on PRIMARY
XPKObject_Security
Fields in Object_Security Table:
Keys and Null Option:
Data Type:
Description:
Field Name:
NOT NULL
DBINT
Specifies the access level the group has to the object. To see values.
click 
.
AccessLevel
NOT NULL
CHANGESTAMP
Incremented when the record is changed in the central database.
ChangeStamp
AK-1 NOT NULL
DBINT
Identifies the specific object.
ObjectID
PK NOT NULL
DBINT
A unique identifier for the row.
ObjectSecurityID
AK-1 NOT NULL
DBINT
Identifies the type of object.
ObjectType
AK-1, IE-1 NOT NULL
varchar(64)
Identifies the user group.
UserGroupName
Database Schema Handbook Cisco ICM/IPCC Enterprise & Hosted Editions 7.2(2)
249
Chapter 2:  All Tables
Object_Security Table