Project

General

Profile

« Previous | Next » 

Revision 7043

Added by Aaron Marcuse-Kubitza over 11 years ago

make_analytical_db: Fixed bug where can't give public_ select access to all analytical_db views because this apparently adds access rather than passing through the underlying table's permissions

View differences:

make_analytical_db
23 23 
CREATE VIEW $analyt_table AS
24 24 
SELECT * FROM $public_table;
25 25 
GRANT SELECT ON TABLE $analyt_table TO bien_read;
26 
GRANT SELECT ON TABLE $analyt_table TO public_;
27 
    -- actual access depends on underlying table's permissions
28 26 
EOF
29 27 
}
30 28 

  		




  ......




  42
  40
  
    
$(mk_analytical_table taxon_trait)


  		




  43
  41
  
    
$(mk_analytical_table analytical_stem)


  		




  44
  42
  
    
$(mk_analytical_table provider_count)


  		




  
  43
  
    
GRANT SELECT ON TABLE analytical_db.provider_count TO public_;


  		




  45
  44
  
    
$(mk_analytical_table analytical_aggregate)


  		




  46
  45
  
    
EOF


  		




  47
  46
  
    

  		












Also available in:  Unified diff