Revision 6854
Added by Aaron Marcuse-Kubitza almost 12 years ago
| 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