postgres.git / summary / log / commit / refs
commit 22297cd65fa5efeffebcfaebfdda174dcdbd821a
Author: Bruce Momjian <bruce@momjian.us>
Date: Thu Aug 31 19:14:18 2023 +0000
First released in: 16.0
doc: PG 16 relnotes: clarify LOCK TABLE description
Backpatch-through: 16 only
doc/src/sgml/release-16.sgml | 15 ++++++++-------
1 file changed, 8 insertions(+), 7 deletions(-)
diff --git a/doc/src/sgml/release-16.sgml b/doc/src/sgml/release-16.sgml
index 2eb172eaa63..9816012631c 100644
--- a/doc/src/sgml/release-16.sgml
+++ b/doc/src/sgml/release-16.sgml
@@ -948,14 +948,15 @@ Author: Jeff Davis <jdavis@postgresql.org>
</para>
<para>
- Previously the ability to perform <command>LOCK
- TABLE</command> at various lock levels was bound to
- specific query-type permissions. For example, <link
+ Previously a user's ability to perform <command>LOCK
+ TABLE</command> at various lock levels was limited to the
+ lock levels required by the commands they had permission
+ to execute on the table. For example, someone with <link
linkend="sql-update"><command>UPDATE</command></link>
- could perform all lock levels except
- <literal>ACCESS SHARE</literal>, which required <link
- linkend="sql-select"><command>SELECT</command></link> permissions.
- Now <command>UPDATE</command> can issue all lock levels. MORE?
+ permission could perform all lock levels except <literal>ACCESS
+ SHARE</literal>, even though it was a lesser lock level. Now users
+ can issue lesser lock levels if they already have permission for
+ greater lock levels.
</para>
</listitem>
[parent: d5feb6011e62]