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 1tk65H-00HXGs-MD for pgsql-general@arkaria.postgresql.org; Mon, 17 Feb 2025 18:43:11 +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 1tk65G-001Yz7-9L for pgsql-general@arkaria.postgresql.org; Mon, 17 Feb 2025 18:43:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tk65F-001Yyt-SC for pgsql-general@lists.postgresql.org; Mon, 17 Feb 2025 18:43:09 +0000 Received: from mail-oo1-xc2e.google.com ([2607:f8b0:4864:20::c2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tk65D-001Oyf-2t for pgsql-general@lists.postgresql.org; Mon, 17 Feb 2025 18:43:09 +0000 Received: by mail-oo1-xc2e.google.com with SMTP id 006d021491bc7-5fc13355a5bso2130303eaf.3 for ; Mon, 17 Feb 2025 10:43:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1739817786; x=1740422586; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=ilW3n9YQkE9E7w1+xQVr2yk5gsww1azzGWZyWiEr7PM=; b=e3WHxjGsmVMwREzYD6r5KNddWa4StMOGSKk5bnCh2nSZt790YfUF+I9hkisgUNLb+A ZdDQjo5X0cofRJK56HnNL2j3jbznbRYcV922ldtt7RQi04um4Lm5ZbcN99I8xAqBddoi 4OEyR+IE3SkeWuKp30ImQceY706gIegneqCOC7Pusqz1NFFwQ7x9PlR2nt5RXKyXuqdr 7BGSb1DoW8pUiHFXzuInWYGmU1tHBXhJJFiycvMxpXyMzohc/mzzFKR+qJM5pXWANHNI bvw8TMFJCvCr++E/bEKUDfjuGW9HhcFnFBAHXQf0iWRNhm5ieQmzLm6xfaYxkpmeIHlk n/Mw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1739817786; x=1740422586; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=ilW3n9YQkE9E7w1+xQVr2yk5gsww1azzGWZyWiEr7PM=; b=UKkTWo6hd4sJo32RfkgVeJvayz1Jh7Uvav4Qxxjg5nEpWQstrEvf3dCxH8U+7afL78 Ia/U7DAUg9tepHjP3VYm/XDt/j7bDSLgPJgK8WgdC74gLe7jdva70dv8DdtnYRHPBvQd VAsW7S2TxgpZ4JTKVYAWla0AEi2JrKX9Wpu+gpUjBnOP6H4G1H7YKXM1S3lbVV/LKpZR tn6d6Xnn1QGUJJJEL6Ump6uswhz6TJChC/45ysCE+KQxXoyNgOSmzIHYfCiAr4Pulede cWoz8yLNkIbBjpEGzloMGRI/qsCLqi7g0pPBTwVF9v3pOgal97XAj7wOVVf4aSW2qpQk rakA== X-Forwarded-Encrypted: i=1; AJvYcCW2owyVRFXPrhhGTcYgmS2s88DmanLMJVqzjDSnAYsgiTnVN/pk+CT/2+3ps6lUxe6qUSLZELq7zKk7NvFZ@lists.postgresql.org X-Gm-Message-State: AOJu0YxiD0AbT7TofSFSQlfY1geVv/YvYZW3qBf8k/XA2eJvSMq1OlRc 3vfR8aNCoh+gKMXxVjCiIDkNPWVQOW8S/HIFNrElW5xHIeLJhqPof7X+gFh+RY2XepDWlRBeBK5 c8omzqnRlwEmLkH1LNvtRoWAMA94pgQ== X-Gm-Gg: ASbGnctlLcdigiVKNQ+amSBtt1DGMHqqOnrOU82c510uT+HXzRfyZ4LUl8/+JkmwZCU ljQzMLmdTiG13HE/sfUPczIKLIP76heU5kMdvTmVHO83paa97gCAKBs7+6j8dnTAS1SGVG2Y= X-Google-Smtp-Source: AGHT+IFjB9UWrGPBVqJIDo856yMQv4jwT4CtdB9MunO1yQ+Vt4Qgcn9QvNyRbREVBERsASaUv1Yg2TK5kZeNnX2o+r0= X-Received: by 2002:a05:6808:1527:b0:3e6:f6a:de5c with SMTP id 5614622812f47-3f3eb129d22mr5846226b6e.27.1739817785632; Mon, 17 Feb 2025 10:43:05 -0800 (PST) MIME-Version: 1.0 Received: by 2002:a05:6802:108f:b0:589:13f9:e937 with HTTP; Mon, 17 Feb 2025 10:43:04 -0800 (PST) In-Reply-To: <855988.1739816850@sss.pgh.pa.us> References: <855988.1739816850@sss.pgh.pa.us> From: "David G. Johnston" Date: Mon, 17 Feb 2025 11:43:04 -0700 X-Gm-Features: AWEUYZnc7zNfgy6iphATUCEkZxrDeT8bSq-WyNx40W59AwlTwr7ZHibs0aTQ26w Message-ID: Subject: Re: Clarification on Role Access Rights to Table Indexes To: Tom Lane Cc: Ayush Vatsa , "pgsql-general@lists.postgresql.org" Content-Type: multipart/alternative; boundary="00000000000016332b062e5ae568" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000016332b062e5ae568 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, February 17, 2025, Tom Lane wrote: > Ayush Vatsa writes: > > postgres=3D> SELECT pg_prewarm('pg_class_oid_index'); > > ERROR: permission denied for index pg_class_oid_index > > You'd really have to take that up with the author of pg_prewarm. This is our contrib module so this seems like the expected place to ask such a question. It=E2=80=99s neither a bug nor a topic for -hackers. FTR= , Robert Haas is the author from 2013. Not sure he monitors -general though. David J. --00000000000016332b062e5ae568 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Monday, February 17, 2025, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Ayu= sh Vatsa <ayushvatsa1810@gma= il.com> writes:
> postgres=3D> SELECT pg_prewarm('pg_class_oid_index');<= br> > ERROR:=C2=A0 permission denied for index pg_class_oid_index

You'd really have to take that up with the author of pg_prewarm.

This is our contrib module so this seems like the= expected place to ask such a question.=C2=A0 It=E2=80=99s neither a bug no= r a topic for -hackers.=C2=A0 FTR, Robert Haas is the author from 2013.=C2= =A0 Not sure he monitors -general though.

David J.=

--00000000000016332b062e5ae568--