Skip to content
Snippets Groups Projects
Select Git revision
  • master
  • subtemplate
  • release_7.0.6
  • php84
  • 6.x
  • v5.x-test
  • 5x
  • 7.1.0
  • 7.0.6
  • 7.0.5
  • 7.0.4
  • 7.0.3
  • 7.0.2
  • 7.0.1
  • 7.0.0
  • 6.1.7
  • 6.1.6
  • 6.1.5
  • 6.1.4
  • 6.1.3
  • 6.1.2
  • 6.1.1
  • 6.1.0
  • 6.0.3
  • 6.0.2
  • 5.0.6
  • 6.0.1
27 results

002_privileges.sql

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';