Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision e81f9f44

Von Bernd Bleßmann vor fast 3 Jahren hinzugefügt

  • ID e81f9f44ba8ddcac6d93659ca2aff1b649a1e3a7
  • Vorgänger 3ad96f21
  • Nachfolger c4a13349

kein DB-Fehler bei fehlender Gruppe Vollzugriff im DB-Upgrade f. Nur-Lese-Rechte

Ist beim Test aufgefallen - dort gibt es die Gruppe nicht.

Unterschiede anzeigen:

sql/Pg-upgrade2-auth/rights_view_docs.sql
59 59 
          FALSE);
60 60 

  		




  61
  61
  
    

  		




  
  62
  
    
-- INSERT INTO auth.group_rights (group_id, "right", granted)


  		




  
  63
  
    
--    SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'sales_quotation_view',         true UNION


  		




  
  64
  
    
--    SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'sales_order_view',             true UNION


  		




  
  65
  
    
--    SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'sales_delivery_order_view',    true UNION


  		




  
  66
  
    
--    SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'sales_invoice_view',           true UNION


  		




  
  67
  
    
--    SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'request_quotation_view',       true UNION


  		




  
  68
  
    
--    SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'purchase_order_view',          true UNION


  		




  
  69
  
    
--    SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'purchase_delivery_order_view', true UNION


  		




  
  70
  
    
--    SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'purchase_invoice_view',        true;


  		




  
  71
  
    

  		




  62
  72
  
    
INSERT INTO auth.group_rights (group_id, "right", granted)


  		




  63
  
  
    
   SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'sales_quotation_view',         true UNION


  		




  64
  
  
    
   SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'sales_order_view',             true UNION


  		




  65
  
  
    
   SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'sales_delivery_order_view',    true UNION


  		




  66
  
  
    
   SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'sales_invoice_view',           true UNION


  		




  67
  
  
    
   SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'request_quotation_view',       true UNION


  		




  68
  
  
    
   SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'purchase_order_view',          true UNION


  		




  69
  
  
    
   SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'purchase_delivery_order_view', true UNION


  		




  70
  
  
    
   SELECT (SELECT id FROM auth.group WHERE name = 'Vollzugriff'), 'purchase_invoice_view',        true;


  		




  
  73
  
    
   SELECT id, 'sales_quotation_view',         true FROM auth.group WHERE name = 'Vollzugriff' UNION


  		




  
  74
  
    
   SELECT id, 'sales_order_view',             true FROM auth.group WHERE name = 'Vollzugriff' UNION


  		




  
  75
  
    
   SELECT id, 'sales_delivery_order_view',    true FROM auth.group WHERE name = 'Vollzugriff' UNION


  		




  
  76
  
    
   SELECT id, 'sales_invoice_view',           true FROM auth.group WHERE name = 'Vollzugriff' UNION


  		




  
  77
  
    
   SELECT id, 'request_quotation_view',       true FROM auth.group WHERE name = 'Vollzugriff' UNION


  		




  
  78
  
    
   SELECT id, 'purchase_order_view',          true FROM auth.group WHERE name = 'Vollzugriff' UNION


  		




  
  79
  
    
   SELECT id, 'purchase_delivery_order_view', true FROM auth.group WHERE name = 'Vollzugriff' UNION


  		




  
  80
  
    
   SELECT id, 'purchase_invoice_view',        true FROM auth.group WHERE name = 'Vollzugriff';


  		












Auch abrufbar als:  Unified diff