Project

General

Profile

« Previous | Next » 

Revision 9898

schemas/vegbien.sql: allow public_ to view lookup tables (cultivated_family_locations, higher_plant_group_nodes)

View differences:

schemas/vegbien.my.sql
7230 7230

  
7231 7231

  
7232 7232

  
7233

  
7233 7234
--
7234 7235
-- Name: family_higher_plant_group; Type: ACL; Schema: public; Owner: -
7235 7236
--
......
7571 7572

  
7572 7573

  
7573 7574

  
7575

  
7574 7576
--
7575 7577
-- Name: locationeventcontributor; Type: ACL; Schema: public; Owner: -
7576 7578
--
schemas/vegbien.sql
8492 8492
REVOKE ALL ON TABLE cultivated_family_locations FROM bien;
8493 8493
GRANT ALL ON TABLE cultivated_family_locations TO bien;
8494 8494
GRANT SELECT ON TABLE cultivated_family_locations TO bien_read;
8495
GRANT SELECT ON TABLE cultivated_family_locations TO public_;
8495 8496

  
8496 8497

  
8497 8498
--
......
8833 8834
REVOKE ALL ON TABLE higher_plant_group_nodes FROM bien;
8834 8835
GRANT ALL ON TABLE higher_plant_group_nodes TO bien;
8835 8836
GRANT SELECT ON TABLE higher_plant_group_nodes TO bien_read;
8837
GRANT SELECT ON TABLE higher_plant_group_nodes TO public_;
8836 8838

  
8837 8839

  
8838 8840
--

Also available in: Unified diff