Content-Type: multipart/mixed; boundary="------------H4LtcCyggsDjtu11zEIQHtLD"
Message-ID: <931e012a-57ba-41ba-9b88-24323a46dec5@packi.ch>
Date: Thu, 5 Jun 2025 15:29:46 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
To: pgsql-docs@lists.postgresql.org
Content-Language: en-US
From: =?UTF-8?Q?Patrick_St=C3=A4hlin?= <me@packi.ch>
Subject: Add sentence about SECURITY LABEL object ownership
Archived-At: 
 <https://www.postgresql.org/message-id/931e012a-57ba-41ba-9b88-24323a46dec5%40packi.ch>
Precedence: bulk

This is a multi-part message in MIME format.
--------------H4LtcCyggsDjtu11zEIQHtLD
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

I noticed that we don't document that you need to own the object being 
modified by SECURITY LABEL.

Page: https://www.postgresql.org/docs/current/sql-security-label.html

I've attached a patch that would have answered that question (for me) 
without diving into the code.

Thanks,
Patrick
--------------H4LtcCyggsDjtu11zEIQHtLD
Content-Type: text/x-patch; charset=UTF-8;
 name="0001-Document-ownership-requirement-for-SECURITY-LABEL-v1.patch"
Content-Disposition: attachment;
 filename*0="0001-Document-ownership-requirement-for-SECURITY-LABEL-v1.pa";
 filename*1="tch"
Content-Transfer-Encoding: base64

RnJvbSAzMThhMzdhMzVmMWI5ZjE5MTVhZTAzZGY4NjlmYjUxYjA0ZjEzNTNlIE1vbiBTZXAg
MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiA9P1VURi04P3E/UGF0cmljaz0yMFN0PUMzPUE0aGxp
bj89IDxtZUBwYWNraS5jaD4KRGF0ZTogVGh1LCA1IEp1biAyMDI1IDE1OjEwOjAxICswMjAw
ClN1YmplY3Q6IFtQQVRDSF0gRG9jdW1lbnQgb3duZXJzaGlwIHJlcXVpcmVtZW50IGZvciBT
RUNVUklUWSBMQUJFTAoKQ2xhcmlmeSB0aGF0IHlvdSBuZWVkIG93bmVyc2hpcCBvZiBvYmpl
Y3RzIHlvdSBpc3N1ZSBTRUNVUklUWSBMQUJFTCBvbi4KLS0tCiBkb2Mvc3JjL3NnbWwvcmVm
L3NlY3VyaXR5X2xhYmVsLnNnbWwgfCA0ICsrKysKIDEgZmlsZSBjaGFuZ2VkLCA0IGluc2Vy
dGlvbnMoKykKCmRpZmYgLS1naXQgYS9kb2Mvc3JjL3NnbWwvcmVmL3NlY3VyaXR5X2xhYmVs
LnNnbWwgYi9kb2Mvc3JjL3NnbWwvcmVmL3NlY3VyaXR5X2xhYmVsLnNnbWwKaW5kZXggZTVl
NWZiNDgzZTkuLmRkY2Y5MmM5NjdlIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvcmVmL3Nl
Y3VyaXR5X2xhYmVsLnNnbWwKKysrIGIvZG9jL3NyYy9zZ21sL3JlZi9zZWN1cml0eV9sYWJl
bC5zZ21sCkBAIC04NCw2ICs4NCwxMCBAQCBTRUNVUklUWSBMQUJFTCBbIEZPUiA8cmVwbGFj
ZWFibGUgY2xhc3M9InBhcmFtZXRlciI+cHJvdmlkZXI8L3JlcGxhY2VhYmxlPiBdIE9OCiAg
ICBiYXNlZCBvbiBvYmplY3QgbGFiZWxzLCByYXRoZXIgdGhhbiB0cmFkaXRpb25hbCBkaXNj
cmV0aW9uYXJ5IGFjY2VzcyBjb250cm9sCiAgICAoREFDKSBjb25jZXB0cyBzdWNoIGFzIHVz
ZXJzIGFuZCBncm91cHMuCiAgIDwvcGFyYT4KKworICA8cGFyYT4KKyAgIFlvdSBtdXN0IG93
biB0aGUgZGF0YWJhc2Ugb2JqZWN0IHRvIHVzZSB0aGUgPGNvbW1hbmQ+U0VDVVJJVFkgTEFC
RUw8L2NvbW1hbmQ+LgorICA8L3BhcmE+CiAgPC9yZWZzZWN0MT4KIAogIDxyZWZzZWN0MT4K
LS0gCjIuNDguMQoK

--------------H4LtcCyggsDjtu11zEIQHtLD--