Re: Add sentence about SECURITY LABEL object ownership - Mailing list pgsql-docs

From Tom Lane
Subject Re: Add sentence about SECURITY LABEL object ownership
Date
Msg-id 1284778.1749136742@sss.pgh.pa.us
Whole thread Raw
In response to Re: Add sentence about SECURITY LABEL object ownership  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Add sentence about SECURITY LABEL object ownership
List pgsql-docs
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> On Thu, 2025-06-05 at 15:29 +0200, Patrick Stählin wrote:
>> I noticed that we don't document that you need to own the object being
>> modified by SECURITY LABEL.

Yeah, clearly a documentation oversight.

> Wouldn't it be more accurate to say that you have to be a member of the owning role?
> But perhaps that would be complicated enough to confuse many users.
> In general, +1 for documenting that.

Our standard boilerplate for this is, eg,

   You must own the table to use <command>ALTER TABLE</command>.

I don't see a reason to do it differently here.

            regards, tom lane



pgsql-docs by date:

Previous
From: Patrick Stählin
Date:
Subject: Re: Add sentence about SECURITY LABEL object ownership
Next
From: Laurenz Albe
Date:
Subject: Re: Add sentence about SECURITY LABEL object ownership