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

746 DCFM Professional Plus User Manual
53-1001774-01
Sybase and Derby Database Fields
D
Reports
Role Based Access Control
TABLE 180 REPORT_TYPE
Field Definition Format Size
ID* Meta Data for available reports. int
NAME Report name. varchar 128
DESCRIPTION Report type description. varchar 256
TABLE 181 GENERATED_REPORT
Field Definition Format Size
ID*
int
NAME Report name. varchar 256
TYPE_ID Report type. int
EFCM_USER The Management application user who has
generated this report.
varchar 128
REPORT_OBJECT Report object BLOB. image
TIMESTAMP_ Timestamp when the report is generated. timestamp
TABLE 182 USER_ROLE_MAP
Field Definition Format Size
USER_NAME* User name. varchar 128
ROLE_ID* Role ID, which is mapped for the user. int
TABLE 183 ROLE
Field Definition Format Size
ID* int
NAME Role name. varchar 128
DESCRIPTION Role description. varchar 512
TABLE 184 ROLE_PRIVILEGE_MAP
Field Definition Format Size
ROLE_ID* User role ID. int
PRIVILEGE_ID* Privilege ID. int
PERMISSION Privilege permission:
1 = RO
2 = RW
0 = No privilege
smallint