Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitbf18402

Browse files
committed
Add note about access permission checks by inherited TRUNCATE and LOCK TABLE.
Inherited queries perform access permission checks on the parenttable only. But there are two exceptions to this rule in v12 or before;TRUNCATE and LOCK TABLE commands through a parent table checkthe permissions on not only the parent table but also the childrentables. Previously these exceptions were not documented.This commit adds the note about these exceptions, into the document.Back-patch to v9.4. But we don't apply this commit to the masterbecause commite6f1e56 already got rid of the exception aboutinherited TRUNCATE and upcoming commit will do for the exceptionabout inherited LOCK TABLE.Author: Amit LangoteReviewed-by: Fujii MasaoDiscussion:https://postgr.es/m/CA+HiwqHfTnMU6SUkyHxCmpHUKk7ERLHCR3vZVq19ZOQBjPBLmQ@mail.gmail.com
1 parentd034ab0 commitbf18402

File tree

1 file changed

+5
-1
lines changed

1 file changed

+5
-1
lines changed

‎doc/src/sgml/ddl.sgml

Lines changed: 5 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2323,7 +2323,11 @@ VALUES ('New York', NULL, NULL, 'NY');
23232323
access privilege checking. This preserves the appearance that the
23242324
data is (also) in the parent table. Accessing the child tables
23252325
directly is, however, not automatically allowed and would require
2326-
further privileges to be granted.
2326+
further privileges to be granted. Two exceptions to this rule are
2327+
<command>TRUNCATE</command> and <command>LOCK TABLE</command>,
2328+
where permissions on the child tables are always checked,
2329+
whether they are processed directly or recursively via those commands
2330+
performed on the parent table.
23272331
</para>
23282332

23292333
<sect2 id="ddl-inherit-caveats">

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp