Reference Guide > TDV and Business Directory System Tables > SYS_PRINCIPAL_SETS
 
SYS_PRINCIPAL_SETS
The SYS_PRINCIPAL_SETS system table provides a list of principal set definitions. Users see no rows unless they have the ACCESS_TOOLS right. Users with this right can see all rows.
Note: Unlike most system tables, this table is under /system/deployment in the Studio resource tree.
Column
TDV
JDBC Data Type
Nullable
Description
PRINCIPAL_SET_NAME
VARCHAR(255)
 
Name of the resource set.
SITE_NAME
VARCHAR(255)
 
Name of the site.
DEFINITION
VARCHAR(2147483647)
 
Definition of principal set.
ANNOTATION
VARCHAR(2147483647)
 
Annotation.
STATUS
VARCHAR(2147483647)
 
Impact status.
OWNER
VARCHAR(2147483647)
 
Owner of the principal set.
CREATE_TIME
BIGINT
 
Principal set creation time.
MODIFY_TIME
BIGINT
 
Time of last modification to the principal set.
MODIFY_USER
VARCHAR(2147483647)
 
Name of last person to modify the principal set.