Revision 6854
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 6487 | 6487 |
|
| 6488 | 6488 |
|
| 6489 | 6489 |
|
| 6490 |
|
|
| 6490 | 6491 |
-- |
| 6491 | 6492 |
-- Name: place; Type: ACL; Schema: public; Owner: - |
| 6492 | 6493 |
-- |
| ... | ... | |
| 6667 | 6668 |
|
| 6668 | 6669 |
|
| 6669 | 6670 |
|
| 6671 |
|
|
| 6670 | 6672 |
-- |
| 6671 | 6673 |
-- Name: sourcelist; Type: ACL; Schema: public; Owner: - |
| 6672 | 6674 |
-- |
| schemas/vegbien.sql | ||
|---|---|---|
| 7618 | 7618 |
REVOKE ALL ON SCHEMA public FROM bien; |
| 7619 | 7619 |
GRANT ALL ON SCHEMA public TO bien; |
| 7620 | 7620 |
GRANT USAGE ON SCHEMA public TO bien_read; |
| 7621 |
GRANT USAGE ON SCHEMA public TO public_; |
|
| 7621 | 7622 |
|
| 7622 | 7623 |
|
| 7623 | 7624 |
-- |
| ... | ... | |
| 7798 | 7799 |
REVOKE ALL ON TABLE source FROM bien; |
| 7799 | 7800 |
GRANT ALL ON TABLE source TO bien; |
| 7800 | 7801 |
GRANT SELECT ON TABLE source TO bien_read; |
| 7802 |
GRANT SELECT ON TABLE source TO public_; |
|
| 7801 | 7803 |
|
| 7802 | 7804 |
|
| 7803 | 7805 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: Granted the public_ user read-only access to the contents of the source table