Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t8N57-003mIH-Bg for pgsql-general@arkaria.postgresql.org; Tue, 05 Nov 2024 17:11:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t8N53-00GCw9-SD for pgsql-general@arkaria.postgresql.org; Tue, 05 Nov 2024 17:11:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t8N53-00GCvz-9B for pgsql-general@lists.postgresql.org; Tue, 05 Nov 2024 17:11:01 +0000 Received: from mail-oo1-xc36.google.com ([2607:f8b0:4864:20::c36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1t8N51-000Kmd-8n for pgsql-general@lists.postgresql.org; Tue, 05 Nov 2024 17:11:00 +0000 Received: by mail-oo1-xc36.google.com with SMTP id 006d021491bc7-5edf76cd843so1582603eaf.1 for ; Tue, 05 Nov 2024 09:10:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1730826658; x=1731431458; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=m3EtHmMCxkcZT11IwkVzQIh0NfJ84yUmQzwqIoGsFO0=; b=UnDmz1ppMbauLqzamHB8WBxo2nKn2C9FO9vB/7U17gz3QjZUoaKYIUXyQXKd0XqI5m L4u2Y6QNFiy8njtyl6CYiA9AsJj5RpaABS1h32MZ39lSypSYbd7Z3Y2Nb84RnkwM7n0j V6VRwMvVJIJ1jq61bDtz/Cas8yJzZDTHRS5+TW1QAUT7phGZ0Uausif+CgDcd9YGknQi bjU5+q1wF+E8jFikiRfcfOwDhrB9HILmlN6OimpW9wrAYPZbCSb2Nyg1zC69KKxCFuRV Fhz3fHxsLFaFqLDnPj1bznrhCbCKXDqSpuxTm1+uDFsZfys0E+PfU6qXlDyv6pT6K6BZ wQjA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1730826658; x=1731431458; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=m3EtHmMCxkcZT11IwkVzQIh0NfJ84yUmQzwqIoGsFO0=; b=ccEJbKLONIgSI+FHKrDXQF2K/7qzvsNfhXEZwY3/GYCgz+eh8LEfDIJxgn6wEM9cf6 MyE9QFuzOfKeMigBNyCr0IC7gSBGobeioYKqx4tvhTZy6WRDMR6uJzJlvArd26QaUeHZ AXdRKqvy7R9UCCCPg84MWczhtLut1sEo2v3DZ6pW2c9pEIpMKc1Kp47n/L8ztxz4Eyf5 HWyy6/+Myh/DYEpSsR1MgBCaf0u6jQNmNfV7uEnUTGx49KetFLphsGfl+6geMPMhc24s 5rusR2FUTbrZa1Qk8Q2DAA/ucalYUsIB00fggvgmMNcxPZVVYgh4wkXKtYI1syt9onV8 Rs3Q== X-Gm-Message-State: AOJu0Yw7jqbdjk6/pXPtkAP2k4LgHlQAIzCXqnB6vEVCA2X+6UE2GLn9 syf3wW/ZZvsf/+yaSFaxjdNnycYTR1Sk4lT3zanlAXxk/iPeRlJ+OcVMU5ZHEaCYy0eN0YpZPVX yNGY5QvoQzOyVu97hQiXgUG0T0JMIwMmK X-Google-Smtp-Source: AGHT+IFB7rauyN5PRNmkLvMZyDepCFiMMEoELQMKqgceVBlzLS20D6S1WAYxA0lT5DOCmd0zLZ049Ufzo/PsPNTrFNw= X-Received: by 2002:a05:6820:4b8c:b0:5eb:8488:c80b with SMTP id 006d021491bc7-5ede6591440mr11737892eaf.6.1730826658546; Tue, 05 Nov 2024 09:10:58 -0800 (PST) MIME-Version: 1.0 From: Dominique Devienne Date: Tue, 5 Nov 2024 18:10:46 +0100 Message-ID: Subject: Switching to NOINHERIT user triggers #XX000 error To: pgsql-general@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi. Still working on porting our stuff to v16+, with the ROLE changes. I'm facing a new issue. The same code and unit test works in v14, when the LOGIN user running the test is INHERIT or NOINHERIT. On v16 and v17 though, it works with INHERIT, but with NOINHERIT, I get: GRANT "...:USER" TO "ddevienne" #XX000: ERROR: no possible grantors Any clue to what this means, so I can start looking in the right place? In all 3 (or 6) cases, the code is the same, the client-side is running libpq 17, it's only the server that changes. The LOGIN user is the same, with the same pg_roles attributes, with again the variable being INHERIT or not. --DD