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 1v1Sj4-008vGK-CZ for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Sep 2025 16:52:18 +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 1v1Sj3-00Edt9-1y for pgsql-hackers@arkaria.postgresql.org; Wed, 24 Sep 2025 16:52:17 +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 1v1Sj2-00Edt1-Mg for pgsql-hackers@lists.postgresql.org; Wed, 24 Sep 2025 16:52:16 +0000 Received: from mail-io1-xd35.google.com ([2607:f8b0:4864:20::d35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v1Siy-002f3O-1b for pgsql-hackers@postgresql.org; Wed, 24 Sep 2025 16:52:16 +0000 Received: by mail-io1-xd35.google.com with SMTP id ca18e2360f4ac-8877b60f7a5so3931139f.3 for ; Wed, 24 Sep 2025 09:52:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1758732732; x=1759337532; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=54YIiW6FSB2CSUwcPIJ3XAwlv4L9OU3Mp+xfx06Zwyg=; b=NOBN5jB15rBtXWeaBf93NhYu8U1BNJXISh1Vim3sxoExLEQZ4BaDEZZIfAY1hRdfjJ +F+i+pIh2poii6qbi2aNYt270JHHaN+GQIy7HzRLuDX68tJvDrrIUmUoo3H98UeV2IhI o1ij0NEjTOJqUTwfPVUur5XtZXaoKU+5iNmjrfjrYqVXreuPXBalv9PmPto7fkBrtwTU k7uwLwcbeYZUDoznV9MJC5hVQLsYHl2ash3tY+B0bq+56Hp9SgjjK90LJDrszFdJH0Cq wwUZTGQX+Rd4zKwdf690YE4Mrc9P3AvomGCdzVRfy5qvqqJrXlrjF+ZYVqQO+rErYZ93 C8Cw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758732732; x=1759337532; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=54YIiW6FSB2CSUwcPIJ3XAwlv4L9OU3Mp+xfx06Zwyg=; b=w9nbuLP0/aBRFGGTWZ1iQTy1kkmDu/6TnWGE8aHgNanHnOqq+1Y0sn2ks5XjM/wpCG Bjuhh5PPAlUDCrXLwpvOuhximbvOqQ5zFPFORePYIx++i+OrT6MHVziIMR1yh1TL5iND qYnpSTfdI3p0bQFljc0doNMnaHJYCfK4vWvs1XjbqeDaPTqtGNH4OJMm6CPzp+p6dXLT AJ69nDrJp2njzAO9DCOAsANfu6wXOGU24op5yb58VWDliqW3fmsBm+ikbNVRr2UYfqka RYraTLnQPwogtCA+23UHzvOXrntDrTUdJ8izqJdOa2LPe8OE+GcbNyKvXF81EF7CSghG Ci7w== X-Forwarded-Encrypted: i=1; AJvYcCVDscVw/c9FPrUBYJdh8wPX2fhbDgD6JfVWTbv7I4XdOw/4Qe6nQ4hS+6OKrD3XBPG4h8QHgCBDLxgibnbV@postgresql.org X-Gm-Message-State: AOJu0Yw1fUfhJMCudfSP6GZGMRe0Vao2rFQsfsyTpQgS5AAicTa/7IgB MQOdJail4837jCqyjgAM+1IBp01nC6a5ov0AVu33BXdv+MSgnAUA6F+C X-Gm-Gg: ASbGnct5gDz6XyggiS3wfJxTxHh3agC8uuZoxYOraWjJVc9bOnJdbJyZaHc/EOhFLhy ZK/0yB8o6hmSZBOwZI0348tBsGzoTWztH6QoRqfeNc6t86Ot9cpt/CAfo5mGMdqLkyxHzZSKXCx DDSqJxWF8YD4vQHBWapBiMVrTGDhna1E3ITaL1sbFwubuNcwW6qTmm4KBlvdzjNRAk33r1IwQz5 iuI5x/NLibb42Cy2O8Svew5RhHq6aDh9GDSFQUQ2nhj4YNiolQOv2U8Jmh4oI7kYvZpn71/QM1n bNlL62O+yGtHKsI3cKFCaOW49EmBnf8Ko9CQLUB71qoWbKj1Bg7/OqkHkuc2m88Idsl4m2T4zKC o86gHNmZe9l9Gm1D/pj21ZDuRf3HWuoX6ApLZz3lbdToBeP50ZEhZcs1B3BE0pI0GA28eBru7y5 mAZEHQpGsWRUw1 X-Google-Smtp-Source: AGHT+IHXOc75emrlo4hVESej075T6HxVyY7ojh7Ha8xEOHIPkelZT0NLpeo1U3EEvJnHRrJ8gx9rqw== X-Received: by 2002:a05:6e02:3e93:b0:3f6:5e71:1519 with SMTP id e9e14a558f8ab-425955fce57mr5068505ab.4.1758732731911; Wed, 24 Sep 2025 09:52:11 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-4244a36ad61sm84777775ab.6.2025.09.24.09.52.10 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 24 Sep 2025 09:52:11 -0700 (PDT) Date: Wed, 24 Sep 2025 11:52:09 -0500 From: Nathan Bossart To: Tom Lane Cc: Ayush Vatsa , Robert Haas , "David G. Johnston" , PostgreSQL Hackers Subject: Re: Clarification on Role Access Rights to Table Indexes Message-ID: References: <149429.1741472260@sss.pgh.pa.us> <279947.1741535285@sss.pgh.pa.us> <3432170.1758730414@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="mOdMvbysYmLnv0P7" Content-Disposition: inline In-Reply-To: <3432170.1758730414@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --mOdMvbysYmLnv0P7 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Sep 24, 2025 at 12:13:34PM -0400, Tom Lane wrote: > Nathan Bossart writes: >> * RangeVarCallbackForReindexIndex() was checking privileges on the table >> before locking it, so I reversed it in 0002. > > Don't we do that intentionally, to make sure someone can't cause DOS > on a table they have no privileges on? Ah, right. I switched it back in v4. -- nathan --mOdMvbysYmLnv0P7 Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename=v4-0001-fix-priv-checks-in-stats-code.patch