Project

General

Profile

« Previous | Next » 

Revision 7043

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:

bin/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