Timeline for How can I create readonly user for backups in PostgreSQL?
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 11, 2019 at 16:27 | comment | added | dthor |
Also, if your tables use bigint your readonly user will likely also need GRANT SELECT ON ALL SEQUENCES
|
|
| Mar 11, 2019 at 16:26 | comment | added | dthor |
I noticed that when running ALTER DEFAULT PRIVILEGES ... myReadonlyUser, 2 additional lines are added to the dump: ALTER DEFAULT PRIVILEGES FOR ROLE root IN SCHEMA public REVOKE ALL ON TABLES FROM PUBLIC; ALTER DEFAULT PRIVILEGES FOR ROLE root IN SCHEMA public REVOKE ALL ON TABLES FROM root;. Sounds like this will mean root won't be able to do anything on new tables. Is this true?
|
|
| Jan 12, 2017 at 5:28 | history | edited | Evan Carroll | CC BY-SA 3.0 |
added 158 characters in body
|
| Jan 12, 2017 at 5:20 | history | edited | Evan Carroll | CC BY-SA 3.0 |
deleted 252 characters in body
|
| Jan 12, 2017 at 5:09 | history | answered | Evan Carroll | CC BY-SA 3.0 |