Name Type MSSql Type Oracle Type DB2 Nullable Description
UACL_OH_Idnr int NUMBER(38,0) int false IDNR of USR or USG depending on UACL_Typ
UACL_Lnr smallint NUMBER(38,0) smallint false ascending number
UACL_Filter0 varchar (8) VARCHAR2 (8 CHAR) varchar(8) true authorization type like USER, SERV..., OBJ -> Filter1 = object type
UACL_Filter1 varchar (8) VARCHAR2 (8 CHAR) varchar(8) true filter on object type
UACL_Filter2 varchar (255) VARCHAR2 (255 CHAR) varchar(255) true filter on object name
UACL_Filter3 varchar (200) VARCHAR2 (200 CHAR) varchar(200) true filter on host name (JOB, EVENT, FT-SEND)
UACL_Filter4 varchar (200) VARCHAR2 (200 CHAR) varchar(200) true filter on host name (FT-RECV)
UACL_Filter5 varchar (200) VARCHAR2 (200 CHAR) varchar(200) true filter on user id (JOB, FT-SEND)
UACL_Filter6 varchar (200) VARCHAR2 (200 CHAR) varchar(200) true filter on user id ( FT-RECV)
UACL_Filter7 varchar (255) VARCHAR2 (255 CHAR) varchar(255) true filter on file names (FT-SEND)
UACL_Filter8 varchar (255) VARCHAR2 (255 CHAR) varchar(255) true filter on file names (FT-RECV)
UACL_BitCode int NUMBER(38,0) int false bit array to determine which column is marked
UACL_AuthLevel smallint NUMBER(38,0) smallint false authorization level (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