Skip to content
Snippets Groups Projects
Select Git revision
  • 2d6af793205a88a27f674a92ba6dbe223b8cf7b2
  • master default protected
  • cleanup_fixtures
  • add-openvox
  • freebsd-14
  • remove-legacy-top-scope-syntax
  • rel430
  • tests
  • revert-363-augeas-module-cleanup
  • release-4.1.0
  • puppet8
  • relax-dependencies
  • rel400
  • mode
  • puppet7
  • release-3.1.0
  • freebsd13
  • freebsd11
  • stdlib
  • centos
  • fedora
  • v5.1.0
  • v5.0.0
  • v4.5.0
  • v4.4.0
  • v4.3.0
  • v4.2.1
  • v4.2.0
  • v4.1.0
  • v4.0.0
  • v3.1.0
  • v3.0.0
  • v2.0.0
  • 1.12.0
  • 1.11.0
  • 1.10.0
  • 1.9.0
  • 1.8.0
  • 1.7.0
  • 1.6.0
  • 1.5.0
41 results

postfix-ldap.pp

Blame
  • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    002_privileges.sql 1.85 KiB
    INSERT INTO unicaen_privilege_categorie (code, libelle, ordre, namespace)
    VALUES ('documentmacro', 'Gestion des macros ', 1000, 'UnicaenRenderer\Provider\Privilege');
    INSERT INTO unicaen_privilege_privilege(CATEGORIE_ID, CODE, LIBELLE, ORDRE)
    WITH d(code, lib, ordre) AS (
        SELECT 'documentmacro_index', 'Accéder à l''index', 0 UNION
        SELECT 'documentmacro_ajouter', 'Ajouter', 10 UNION
        SELECT 'documentmacro_modifier', 'Modifier', 20 UNION
        SELECT 'documentmacro_supprimer', 'Supprimer', 50
    )
    SELECT cp.id, d.code, d.lib, d.ordre
    FROM d
    JOIN unicaen_privilege_categorie cp ON cp.CODE = 'documentmacro';
    
    INSERT INTO unicaen_privilege_categorie (code, libelle, ordre, namespace)
    VALUES ('documenttemplate', 'Gestion des templates ', 1100, 'UnicaenRenderer\Provider\Privilege');
    INSERT INTO unicaen_privilege_privilege(CATEGORIE_ID, CODE, LIBELLE, ORDRE)
    WITH d(code, lib, ordre) AS (
        SELECT 'documenttemplate_index', 'Accéder à l''index', 0 UNION
        SELECT 'documenttemplate_ajouter', 'Ajouter', 10 UNION
        SELECT 'documenttemplate_modifier', 'Modifier', 20 UNION
        SELECT 'documenttemplate_supprimer', 'Supprimer', 50
    )
    SELECT cp.id, d.code, d.lib, d.ordre
    FROM d
    JOIN unicaen_privilege_categorie cp ON cp.CODE = 'documenttemplate';
    
    INSERT INTO unicaen_privilege_categorie (code, libelle, ordre, namespace)
    VALUES ('documentcontenu', 'Gestion des rendus ', 1200, 'UnicaenRenderer\Provider\Privilege');
    INSERT INTO unicaen_privilege_privilege(CATEGORIE_ID, CODE, LIBELLE, ORDRE)
    WITH d(code, lib, ordre) AS (
        SELECT 'documentcontenu_index', 'Accéder à l''index', 0 UNION
        SELECT 'documentcontenu_ajouter', 'Ajouter', 10 UNION
        SELECT 'documentcontenu_modifier', 'Modifier', 20 UNION
        SELECT 'documentcontenu_supprimer', 'Supprimer', 50
    )
    SELECT cp.id, d.code, d.lib, d.ordre
    FROM d
    JOIN unicaen_privilege_categorie cp ON cp.CODE = 'documentcontenu';