Skip to main content

Adding new permissions

The role_permissions_type enum (in the database) defines the permissions that can be associated with roles. These permissions are mirrored in the server itself through the DbRolePermissions enum.

The [Entity]Permissions enums (e.g. ThreadPermissions, PostPermissions) associate each entity with the corresponding permissions.

Adding a New Permission to Server​

  1. Add a new type to the role_permissions_type enum in the database.
  2. Add the same permission to the DbRolePermissions enum. Make sure the spelling is the same.
  3. Add the permission to the corresponding [Entity]Permissions enums.

Adding a new permission to the production database​

There is currently no available UI to add permissions to a role. The following queries can be used in its stead.

  1. Run the following query with the correct permission name:
    ALTER TYPE role_permissions_type ADD VALUE 'move_thread';
  2. Add the permission to a role:
    UPDATE roles
    SET permissions = array_cat(permissions, ARRAY['move_thread'::role_permissions_type])
    WHERE roles.id = 1;