MARIProject Database Structure

View Name:MARIFormAuthorization
Based on table:MPBerechtigungen
Group:
Description:Authorization for each form and report

Field Table(Germ.field)/Type Description Related
Application Applikation

NVARCHAR (64) Primary

Module or User Process Code
FunctionName Funktionsname

NVARCHAR (64) Primary

Mode Funktionsmodus

INT Primary

Form Mode
UserType BenutzerTyp

SMALLINT Primary

0=User, 1=CustomerPortalUser,2=special modes clsImportEmployee_eUserType
FunctionDescription Funktionsbezeichnung

NVARCHAR (50)

Description
FunctionID FunktionsbezeichnungID

INT Index

Language ID
FunctionGroup Funktionsgruppe

NVARCHAR (50)

Function Group
FunctionGroupLanguageID FunktionsgruppeID

INT Index

Language ID
LicenseType LizenzTyp

INT

Form Access Method
RightsRead Lesen

BIGINT

Bit Flag MARIUserGroups.RightsRead (WHERE BenutzerTyp=1)
RightsChange Aendern

BIGINT

Bit Flag MARIUserGroups.RightsChange (WHERE BenutzerTyp=1)
RightsInsert Einfuegen

BIGINT

Bit Flag MARIUserGroups.RightsInsert (WHERE BenutzerTyp=1)
RightsDelete Loeschen

BIGINT

Bit Flag MARIUserGroups.RightsDelete (WHERE BenutzerTyp=1)
RightsAll Alles

BIGINT

Bit Flag MARIUserGroups.RightsAll (WHERE BenutzerTyp=1)
HelpID HelpID

INT Index

Reference to F1 Help
ViewRead ViewLesen

SMALLINT (0=false,-1=true)

ViewChange ViewAendern

SMALLINT (0=false,-1=true)

ViewPaste ViewEinfuegen

SMALLINT (0=false,-1=true)

ViewDelete ViewLoeschen

SMALLINT (0=false,-1=true)

ViewAll ViewAlles

SMALLINT (0=false,-1=true)

InfoText InfoText

NTEXT

InfoTextLanguageID InfoTextID

INT Index

UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany