Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
UACL_OH_Idnr int NUMBER(38,0) int int false ID of the user (group) object.
UACL_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number for authentications.
UACL_Filter0 varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Filter for type.
UACL_Filter1 varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Filter for object type.
UACL_Filter2 varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Filter for object name.
UACL_Filter3 varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Filter for agent name (e.g. job, event, ft send).
UACL_Filter4 varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Filter for agent name (e.g. ft receive).
UACL_Filter5 varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Filter for user (e.g. job, ft send).
UACL_Filter6 varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Filter for user (e.g. ft receive).
UACL_Filter7 varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Filter for file names (e.g. ft send).
UACL_Filter8 varchar (255) VARCHAR2 (255 CHAR) varchar(255) varchar (255) true Filter for file names (e.g. ft receive).
UACL_BitCode int NUMBER(38,0) int int false Bit array to determine which authorizations are set (e.g. read, write, modify, execute, etc.)
UACL_AuthLevel smallint NUMBER(38,0) smallint smallint false Authorization level/group to determine the order of the authorization checks. 0 = prohibition

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_UACL UACL_OH_Idnr, UACL_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_UACL_OH UACL_OH_Idnr OH_Idnr

Return to the Index File