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

Commitabecf1a

Browse files
committed
Add documentation:
>>>I think a more accurate description would be "permissions not>>>inherited by children," and that isn't necessarily a bug.>>>>I agree it may not be a bug - but it's more than the permissions not>>being inherited: the parent is affected.>>> Not really, once you understand what's happening. Unless you use> FROM ONLY, selecting from the parent selects from the parent *and*> its children. The parent itself isn't affected, as queries with> FROM ONLY should demonstrate. I understand what you're saying --> that there's an apparent effect on the parent -- but there really> isn't.Sean Burlington
1 parentf810cfb commitabecf1a

File tree

1 file changed

+12
-1
lines changed

1 file changed

+12
-1
lines changed

‎doc/src/sgml/ddl.sgml‎

Lines changed: 12 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.43 2005/08/12 01:35:53 tgl Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.44 2005/08/13 01:55:41 momjian Exp $ -->
22

33
<chapter id="ddl">
44
<title>Data Definition</title>
@@ -1122,6 +1122,17 @@ SELECT name, altitude
11221122
support this <quote>ONLY</quote> notation.
11231123
</para>
11241124

1125+
1126+
<note>
1127+
<title>Inheritance and Permissions</title>
1128+
<para>
1129+
Because permissions are not inherited automatically a user attempting to access
1130+
a parent table must either have at least the same permission for the child table
1131+
or must use the <quote>ONLY</quote> notation. If creating a new inheritance
1132+
relationship in an existing system be careful that this does not create problems.
1133+
</para>
1134+
</note>
1135+
11251136
<note>
11261137
<title>Deprecated</title>
11271138
<para>

0 commit comments

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