Project

General

Profile

« Previous | Next » 

Revision 6717

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/vegbien.sql: sync_*_to_view(): Also add `GRANT SELECT TO bien_read` on the view used to generate the table, in case the permission was lost when the view was modified

View differences:

vegbien.sql
909 909 
CREATE TABLE analytical_aggregate AS SELECT * FROM analytical_aggregate_view LIMIT 0;
910 910 

  		




  911
  911
  
    
GRANT SELECT ON TABLE analytical_aggregate TO bien_read;


  		




  
  912
  
    
GRANT SELECT ON TABLE analytical_aggregate_view TO bien_read;


  		




  912
  913
  
    

  		




  913
  914
  
    
ALTER TABLE analytical_aggregate ALTER COLUMN "institutionCode" SET NOT NULL;


  		




  914
  915
  
    
ALTER TABLE analytical_aggregate ALTER COLUMN "locationName" SET NOT NULL;


  		




  ......




  928
  929
  
    
CREATE TABLE analytical_stem AS SELECT * FROM analytical_stem_view LIMIT 0;


  		




  929
  930
  
    

  		




  930
  931
  
    
GRANT SELECT ON TABLE analytical_stem TO bien_read;


  		




  
  932
  
    
GRANT SELECT ON TABLE analytical_stem_view TO bien_read;


  		




  931
  933
  
    

  		




  932
  934
  
    
ALTER TABLE analytical_stem ALTER COLUMN "institutionCode" SET NOT NULL;


  		




  933
  935
  
    
ALTER TABLE analytical_stem ALTER COLUMN "locationName" SET NOT NULL;


  		




  ......




  949
  951
  
    
CREATE TABLE geoscrub_input AS SELECT * FROM geoscrub_input_view;


  		




  950
  952
  
    

  		




  951
  953
  
    
GRANT SELECT ON TABLE geoscrub_input TO bien_read;


  		




  
  954
  
    
GRANT SELECT ON TABLE geoscrub_input_view TO bien_read;


  		




  952
  955
  
    
$$;


  		




  953
  956
  
    

  		




  954
  957
  
    

  		












Also available in:  Unified diff