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 1sgst5-009gpm-Rm for pgsql-general@arkaria.postgresql.org; Wed, 21 Aug 2024 21:29:03 +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 1sgst3-00FAjV-Q2 for pgsql-general@arkaria.postgresql.org; Wed, 21 Aug 2024 21:29: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 1sgmvj-00CGFq-UL for pgsql-general@lists.postgresql.org; Wed, 21 Aug 2024 15:07:24 +0000 Received: from mail-oi1-x232.google.com ([2607:f8b0:4864:20::232]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sgmvh-000kdH-QA for pgsql-general@lists.postgresql.org; Wed, 21 Aug 2024 15:07:23 +0000 Received: by mail-oi1-x232.google.com with SMTP id 5614622812f47-3db50abf929so4852981b6e.2 for ; Wed, 21 Aug 2024 08:07:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dbtune.com; s=google; t=1724252840; x=1724857640; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=FON9rHoj12o0c/kWQVOjVb72o+A0kItEV84HXk87JTw=; b=TLd2HN4eGrIW5f44KdUHVZC1LYuMBhIavTaqDbdkizbiMZC1RDnGEeis738iijpfHn bnGEcZ003zpjhfqeH+OtgnES/L5w4MgGvqaBE2qP4aNgCmTxYDb1vPxLekYxpcQ9QbEn WpBm7RBHeEFuNbnR+p+a6VfN800F9R8CVghp2iu9PlyEf9GpdFWHTXPuyg71GpLbg9Ia SWQBFScKYKWusPtFc7RyBnCj+UZnBh97kM09eVW9OC5wvtMWcJmB2gqxYxgFT6xCBiBg kKaRVyW1Ei9SQ6mYJqcDQx3gdSL++K7EKt0q+c7MGckAMTCLStifKewE+3ueOpjj7QIs Q3wg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1724252840; x=1724857640; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=FON9rHoj12o0c/kWQVOjVb72o+A0kItEV84HXk87JTw=; b=cpsn7L+Mi0V9zk16Lh0KOB+Dg+cwoFYYiCWjvbVInlyx6ecPHiG9P5K7+RjXSX4Xh7 IVkvOMBIy6Qp5rAxbzXYLWgabtpSqr3ChAFqH1rcKa31zqagLD+KuWwfbcZo1xl1gIoN joIDB1HiwEjl94KUq2xnDUMaI5nj9Qb/DMKjf+cHE1LsApO1OiuT7e7hm1X4DQMV0XXh X8hIuEu/QD11j3L0C57fhgsCKuGUr2/JHkNKR8m4nrikQgZzy8DbCyPD2Wmq0PIFbaaR GQ8t2oZgY7i9set3t0h2lsPq8xwTTR6V+u23b0MdeBvdUF37JusOXXXo7MiWjmPvRe14 Slhg== X-Gm-Message-State: AOJu0Yzvv+DiYXyh4Rd9gG/Vh2mjlOF3/JxvxYyBWEMljoSm9tDp4OVC lL1LcN0OO5CsT68kaL1VrW/H5aKxUSisRGQgUIECrLaKcmyh8YaFoVKTqH5v99I6q+QH7ZQYr5w gpE9hRXGG9Dlj1rbheTQVgvexc4h+OXU9ZguuLVz1mJO53bEnl7E= X-Google-Smtp-Source: AGHT+IHj8B4DrfixKqIA0j4JmSIU3Zbe9sY/Gm2v5qaV5TyuyDLzyOcJmwImpwtXkiQoKAYAP9MJZeZGUAaTkSQteNw= X-Received: by 2002:a05:6808:6491:b0:3d9:3f5d:7b59 with SMTP id 5614622812f47-3de193cbf3emr2918406b6e.0.1724252840107; Wed, 21 Aug 2024 08:07:20 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Costa Alexoglou Date: Wed, 21 Aug 2024 17:07:09 +0200 Message-ID: Subject: Re: insufficient privilege with pg_read_all_stats granted To: Pavel Luzanov Cc: pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000009bea6062032e6e0" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000009bea6062032e6e0 Content-Type: text/plain; charset="UTF-8" > I think the problem is in the NOINHERIT attribute for the abcd role. Indeed that is the issue, thanks for helping find this out > --00000000000009bea6062032e6e0 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
> I think the problem is in the NOINHE= RIT attribute for the abcd role.

Indeed that is the issue, thanks fo= r helping find this out
--00000000000009bea6062032e6e0--