Name Type MSSql Type Oracle Type DB2 Nullable Description
OACL_OH_Idnr int NUMBER(38,0) int false IDNR of the object
OACL_Lnr smallint NUMBER(38,0) smallint false ascending number of the authorizations
OACL_AuthType varchar (8) VARCHAR2 (8 CHAR) varchar(8) true authorization type (USR = USER, USG = user group or for objects)
OACL_AuthIdnr int NUMBER(38,0) int true IDNR of USR respectively USG or OH depending on the type
OACL_BitCode int NUMBER(38,0) int true bit array to indicate which column is selected
OACL_Prohibition smallint NUMBER(38,0) smallint true Prohibition=True Right=False

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OACL OACL_OH_Idnr, OACL_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OACL_OH OACL_OH_Idnr OH_Idnr

Return to the Index File