pg.ddx.io  pgsql-general@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Nathan Bossart <nathandbossart@gmail.com>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Corey Huinker <corey.huinker@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Ayush Vatsa <ayushvatsa1810@gmail.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: Clarification on Role Access Rights to Table Indexes
Date: Wed, 15 Oct 2025 10:39:17 -0500
Message-ID: <aO_AJd3Au9xmSwjD@nathan> (raw)
In-Reply-To: <857a4633aea6ef90bde4156ae351c49794b34732.camel@j-davis.com>
References: <8af53c6e8992aa706e63aafe60a3bcf100b524d1.camel@j-davis.com>
	<7b0e2774cdcc8f522ac82f64a8d7266f353a5094.camel@j-davis.com>
	<aOfXNAFkj_EFm-8q@nathan>
	<aOgmi6avE6qMw_6t@nathan>
	<aOkzoH-pXdBr0ewf@nathan>
	<31a67adbb10b85ff7cddeafe75b9f6505c902e57.camel@j-davis.com>
	<aO1TaPd0YesHy5Sn@nathan>
	<bd0826223bff21bd2ad3d0b1520ee8429568c526.camel@j-davis.com>
	<aO50zOmoRFnB9_IX@nathan>
	<857a4633aea6ef90bde4156ae351c49794b34732.camel@j-davis.com>

On Tue, Oct 14, 2025 at 10:01:37AM -0700, Jeff Davis wrote:
> If we start with an OID, what's the right way to do these kinds of
> checks? Could we do an ACL check, then lock it, then do an ACL check
> again to catch OID wraparound?

I tried something like this upthread [0].  My feeling was that this was a
lot of complexity for not a lot of gain.  Perhaps it's still worth doing,
though.

[0] https://postgr.es/m/aOgmi6avE6qMw_6t%40nathan

-- 
nathan





view thread (53+ messages)  latest in thread

Message-ID: <aO_AJd3Au9xmSwjD@nathan>
Permalink:  ../aO_AJd3Au9xmSwjD@nathan/
Also on:    postgresql.org/message-id/aO_AJd3Au9xmSwjD@nathan

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: nathandbossart@gmail.com, pgsql@j-davis.com, corey.huinker@gmail.com, tgl@sss.pgh.pa.us, ayushvatsa1810@gmail.com, robertmhaas@gmail.com, david.g.johnston@gmail.com, pgsql-hackers@postgresql.org
  Subject: Re: Clarification on Role Access Rights to Table Indexes
  In-Reply-To: <aO_AJd3Au9xmSwjD@nathan>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox