[INFRA-304] Add CREATE privilege to PFS user on archiver database Created: 18/Nov/21 Updated: 19/Nov/21 Resolved: 18/Nov/21 |
|
| Status: | Done |
| Project: | Software Development Infrastructure |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Normal |
| Reporter: | cloomis | Assignee: | Kiyoto Yabe |
| Resolution: | Done | Votes: | 0 |
| Labels: | EngRun | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Description |
|
The archiver can dynamically add columns when the actor keys schema changes. This (ALTER TABLE) requires the CREATE privilege. |
| Comments |
| Comment by Kiyoto Yabe [ 18/Nov/21 ] |
|
I did `GRANT CREATE ON SCHEMA public TO pfs;` but it didn't work for the problem. I think I need change the owner of tables from `admin` to `pfs`, but I cannot revoke `DROP` privilege from `pfs`. |
| Comment by Kiyoto Yabe [ 18/Nov/21 ] |
|
I changed the owner of all archiver tables to `pfs`. |
| Comment by Kiyoto Yabe [ 18/Nov/21 ] |
|
Now it seems to be working, so I close this ticket. |