Project

General

Profile

« Previous | Next » 

Revision 6716

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/vegbien.sql: sync_*_to_view(): Added `GRANT SELECT TO bien_read`

View differences:

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

  		




  
  911
  
    
GRANT SELECT ON TABLE analytical_aggregate TO bien_read;


  		




  
  912
  
    

  		




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


  		




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


  		




  913
  915
  
    

  		




  ......




  925
  927
  
    
DROP TABLE IF EXISTS analytical_stem;


  		




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


  		




  927
  929
  
    

  		




  
  930
  
    
GRANT SELECT ON TABLE analytical_stem TO bien_read;


  		




  
  931
  
    

  		




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


  		




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


  		




  930
  934
  
    

  		




  ......




  943
  947
  
    
    AS $$


  		




  944
  948
  
    
DROP TABLE IF EXISTS geoscrub_input;


  		




  945
  949
  
    
CREATE TABLE geoscrub_input AS SELECT * FROM geoscrub_input_view;


  		




  
  950
  
    

  		




  
  951
  
    
GRANT SELECT ON TABLE geoscrub_input TO bien_read;


  		




  946
  952
  
    
$$;


  		




  947
  953
  
    

  		




  948
  954
  
    

  		












Also available in:  Unified diff