Revision 7042
Added by Aaron Marcuse-Kubitza over 11 years ago
| 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 |
|
| 26 | 28 |
EOF |
| 27 | 29 |
} |
| 28 | 30 |
|
Also available in: Unified diff
make_analytical_db: Give public_ select access to analytical_db views. This causes the actual access to depend on the underlying table's permissions.