Click or drag to resize

UserPermissions

Store administrative permissions for users.

If the user have the flag IsSuperAdmin is true, the information of that table is then not relevant for that user.

The permission is interpreted as a level value (none, read-only, create...) or as a boolean value (manageAllSurveys, accessAllModules ...).

`UserPermissions` table.

Name

Type

Description

UserId

INT FOREIGN KEY NULL

ID of the user

UserProfileId

INT FOREIGN KEY NULL

ID of the user profile

ModuleGuid

UNIQUEIDENTIFIER NOT NULL

GUID of the module associated with the permission

Key

NVARCHAR(50) NOT NULL

Default 'AskiaPortal' keys of the permission:

  • "users" (level)

  • "groups" (level)

  • "userProfiles" (level)

  • "manageAllGroups" (is allowed to)

  • "reachEverybody" (is allowed to)

  • "createSurveys" (is allowed to)

  • "createEmails" (is allowed to)

  • "createServers" (is allowed to)

  • "createApplications" (is allowed to)

Permission

INT NOT NULL

Level of permissions:

  • 0 = None

  • 1 = Read only

  • 2 = Edit only

  • 3 = Create and edit

  • 4 = Full control (Create, edit, delete and restore)

Or is allowed to:

  • 0 = false

  • 1 = true

See Also