Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OACL_OH_Idnr int NUMBER(38,0) int int false ID of the object.
OACL_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number of an object's authorizations.
OACL_AuthType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) true Authorization type. USR = User, USG = User Group
OACL_AuthIdnr int NUMBER(38,0) int int true ID of the user or the user group.
OACL_BitCode int NUMBER(38,0) int int true Bit array to indicate which column is selected.
OACL_Prohibition smallint NUMBER(38,0) smallint smallint true Indicates whether the authorization definition is excluded or not.

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