public inbox for [email protected]help / color / mirror / Atom feed
struggling with GRANT while upgrading from 13 to 16 7+ messages / 3 participants [nested] [flat]
* struggling with GRANT while upgrading from 13 to 16 @ 2024-06-25 17:04 Axel Rau <[email protected]> 0 siblings, 2 replies; 7+ messages in thread From: Axel Rau @ 2024-06-25 17:04 UTC (permalink / raw) To: [email protected] Hi all, I’m getting ERROR: permission denied to grant privileges as role "axel" DETAIL: The grantor must have the ADMIN option on role "daemons". ERROR: permission denied to grant privileges as role "axel" DETAIL: The grantor must have the ADMIN option on role "daemons". ERROR: permission denied to grant privileges as role "axel" DETAIL: The grantor must have the ADMIN option on role "xtrole". ERROR: permission denied to grant privileges as role "axel" DETAIL: The grantor must have the ADMIN option on role "xtrole". while trying load a dump from 13 into 16 server. Correcting this on 13 seems impossible as new syntax/options are required. What would be the upgrade path to fix this? What would be the SQL phrase to do it ? Any help appreciated, Axel --- PGP-Key: CDE74120 ☀ mobile: +49 160 7568212 computing @ chaos claudius ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: struggling with GRANT while upgrading from 13 to 16 @ 2024-06-25 17:28 Steve Midgley <[email protected]> parent: Axel Rau <[email protected]> 1 sibling, 1 reply; 7+ messages in thread From: Steve Midgley @ 2024-06-25 17:28 UTC (permalink / raw) To: Axel Rau <[email protected]>; +Cc: [email protected] On Tue, Jun 25, 2024 at 10:05 AM Axel Rau <[email protected]> wrote: > Hi all, > > I’m getting > > ERROR: permission denied to grant privileges as role "axel" > DETAIL: The grantor must have the ADMIN option on role "daemons". > ERROR: permission denied to grant privileges as role "axel" > DETAIL: The grantor must have the ADMIN option on role "daemons". > ERROR: permission denied to grant privileges as role "axel" > DETAIL: The grantor must have the ADMIN option on role "xtrole". > ERROR: permission denied to grant privileges as role "axel" > DETAIL: The grantor must have the ADMIN option on role "xtrole". > > while trying load a dump from 13 into 16 server. > > Correcting this on 13 seems impossible as new syntax/options are required. > > What would be the upgrade path to fix this? > What would be the SQL phrase to do it ? > Is there a reason you can't grant axel those other roles as admin? Such as: GRANT daemons TO axel WITH ADMIN OPTION; GRANT xtrole TO axel WITH ADMIN OPTION; I may be missing something really basic, but if you do that on v16 before running the load, would that fix it? Maybe there are security implications for your setup that make this unthinkable, but if that's true, having daemons and xtrole connected to these tables / data might be a problem more generally? Steve ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: struggling with GRANT while upgrading from 13 to 16 @ 2024-06-25 17:38 Axel Rau <[email protected]> parent: Steve Midgley <[email protected]> 0 siblings, 1 reply; 7+ messages in thread From: Axel Rau @ 2024-06-25 17:38 UTC (permalink / raw) To: Steve Midgley <[email protected]>; +Cc: [email protected] Hi Steve. > Am 25.06.2024 um 19:28 schrieb Steve Midgley <[email protected]>: > > Is there a reason you can't grant axel those other roles as admin? Such as: > > GRANT daemons TO axel WITH ADMIN OPTION; > GRANT xtrole TO axel WITH ADMIN OPTION; No this worked. (-: I do another dump and try to load it. Thanks a lot, Axel --- PGP-Key: CDE74120 ☀ mobile: +49 160 7568212 computing @ chaos claudius ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: struggling with GRANT while upgrading from 13 to 16 @ 2024-06-25 18:46 Tom Lane <[email protected]> parent: Axel Rau <[email protected]> 1 sibling, 2 replies; 7+ messages in thread From: Tom Lane @ 2024-06-25 18:46 UTC (permalink / raw) To: Axel Rau <[email protected]>; +Cc: [email protected] Axel Rau <[email protected]> writes: > I’m getting > ERROR: permission denied to grant privileges as role "axel" > DETAIL: The grantor must have the ADMIN option on role "daemons". > ERROR: permission denied to grant privileges as role "axel" > DETAIL: The grantor must have the ADMIN option on role "daemons". > ERROR: permission denied to grant privileges as role "axel" > DETAIL: The grantor must have the ADMIN option on role "xtrole". > ERROR: permission denied to grant privileges as role "axel" > DETAIL: The grantor must have the ADMIN option on role "xtrole". > while trying load a dump from 13 into 16 server. First I've heard of such a problem. Could you provide more detail on this? What are the actual roles and privileges involved? Which pg_dump version did you use? regards, tom lane ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: struggling with GRANT while upgrading from 13 to 16 @ 2024-06-26 11:01 Axel Rau <[email protected]> parent: Axel Rau <[email protected]> 0 siblings, 0 replies; 7+ messages in thread From: Axel Rau @ 2024-06-26 11:01 UTC (permalink / raw) To: Steve Midgley <[email protected]>; +Cc: [email protected] > Am 25.06.2024 um 19:38 schrieb Axel Rau <[email protected]>: > >> GRANT daemons TO axel WITH ADMIN OPTION; >> GRANT xtrole TO axel WITH ADMIN OPTION; > No this worked. (-: > I do another dump and try to load it. But this failed as before, Axel --- PGP-Key: CDE74120 ☀ mobile: +49 160 7568212 computing @ chaos claudius ^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: struggling with GRANT while upgrading from 13 to 16 @ 2024-06-26 11:08 Axel Rau <[email protected]> parent: Tom Lane <[email protected]> 1 sibling, 0 replies; 7+ messages in thread From: Axel Rau @ 2024-06-26 11:08 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: [email protected] > Am 25.06.2024 um 20:46 schrieb Tom Lane <[email protected]>: > > First I've heard of such a problem. Could you provide more detail on > this? What are the actual roles and privileges involved? Sent per privat email. > Which > pg_dump version did you use? $ pg_dump --version pg_dump (PostgreSQL) 13.15 Axel --- PGP-Key: CDE74120 ☀ mobile: +49 160 7568212 computing @ chaos claudius ^ permalink raw reply [nested|flat] 7+ messages in thread
* [RESOLVED] Re: struggling with GRANT while upgrading from 13 to 16 @ 2024-06-26 13:38 Axel Rau <[email protected]> parent: Tom Lane <[email protected]> 1 sibling, 0 replies; 7+ messages in thread From: Axel Rau @ 2024-06-26 13:38 UTC (permalink / raw) To: Tom Lane <[email protected]>; Steve Midgley <[email protected]>; +Cc: [email protected] > Am 25.06.2024 um 20:46 schrieb Tom Lane <[email protected]>: > > Axel Rau <[email protected]> writes: >> I’m getting > >> ERROR: permission denied to grant privileges as role "axel" >> DETAIL: The grantor must have the ADMIN option on role "daemons". >> ERROR: permission denied to grant privileges as role "axel" >> DETAIL: The grantor must have the ADMIN option on role "daemons". >> ERROR: permission denied to grant privileges as role "axel" >> DETAIL: The grantor must have the ADMIN option on role "xtrole". >> ERROR: permission denied to grant privileges as role "axel" >> DETAIL: The grantor must have the ADMIN option on role "xtrole". > >> while trying load a dump from 13 into 16 server. > > First I've heard of such a problem. Could you provide more detail on > this? What are the actual roles and privileges involved? Which > pg_dump version did you use? Using version 16 pg_dump fixed the problem. Soorry for the noise and thanks to all help and hints, Axel --- PGP-Key: CDE74120 ☀ mobile: +49 160 7568212 computing @ chaos claudius ^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2024-06-26 13:38 UTC | newest] Thread overview: 7+ messages (download: mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-06-25 17:04 struggling with GRANT while upgrading from 13 to 16 Axel Rau <[email protected]> 2024-06-25 17:28 ` Steve Midgley <[email protected]> 2024-06-25 17:38 ` Axel Rau <[email protected]> 2024-06-26 11:01 ` Axel Rau <[email protected]> 2024-06-25 18:46 ` Tom Lane <[email protected]> 2024-06-26 11:08 ` Axel Rau <[email protected]> 2024-06-26 13:38 ` Axel Rau <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox