Timeline for How can I allow a user to alter tables they do not own in Postgres?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 29 at 6:34 | comment | added | Laurenz Albe |
That sounds like a way forward. Note that an even cleaner solution would be to make the users a member of that admin user. Then they don't need to log in as that user, they can do SET ROLE admin and temporarily become that user.
|
|
| Jun 28 at 16:20 | comment | added | Dave | Thanks, we ended up, just assigning the schema and tables a specific admin user. Then the systems that needed said granular control of altering tables will log in as that admin user. | |
| Jun 28 at 16:19 | vote | accept | Dave | ||
| Jun 27 at 5:05 | history | answered | Laurenz Albe | CC BY-SA 4.0 |