DCFM Professional Plus User Manual (53-1001774-01, June 2010)

DCFM Professional Plus User Manual 747
53-1001774-01
Sybase and Derby Database Fields
D
TABLE 185 PRIVILEGE
Field Definition Format Size
ID* int
NAME Privilege Name. varchar 128
TABLE 186 PRIVILEGE_GROUP_MAP
Field Definition Format Size
GROUP_ID* Privilege group ID. int
PRIVILEGE_ID* Privilege ID. int 128
TABLE 187 PRIVILEGE_GROUP
Field Definition Format Size
ID* int
NAME Privilege group name. varchar 128
TABLE 188 ROLE_PRIVILEGE_INFO
name Source
ID ROLE.ID
ROLE NAME ROLE.NAME
ROLE DESCRIPTION ROLE.DESCRIPTION
ID PRIVILEGE.ID
NAME PRIVILEGE.NAME
PERMISSION ROLE_PRIVILEGE_MAP.PERMISSION
TABLE 189 USER_
Field Definition Format Size
NAME* User name. varchar 128
DESCRIPTION User description. varchar 512
PASSWORD User password. varchar 512
EMAIL User e-mail ID. varchar 1024
NOTIFICATION_ENABLED Flag for e-mail notification. smallint
TABLE 190 USER_RESOURCE_MAP
Field Definition Format Size
USER_NAME* User name. varchar 128
RESOURCE_GROUP_ID* Resource group name, which is mapped for the user. int