diff options
| author | Bruce Momjian <bruce@momjian.us> | 2005-08-13 01:55:41 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2005-08-13 01:55:41 +0000 |
| commit | abecf1afc206e1f46d9202c7ba2122f06a799f8d (patch) | |
| tree | 0d0e45a0929770df15f68235df57c62e3bc9156f /doc/src | |
| parent | f810cfb291e4cb0e0e1bbe1b6e6158dc5367a2c8 (diff) | |
| download | postgresql-abecf1afc206e1f46d9202c7ba2122f06a799f8d.tar.gz postgresql-abecf1afc206e1f46d9202c7ba2122f06a799f8d.zip | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ddl.sgml | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml index abe3b582016..f3a0129778e 100644 --- a/doc/src/sgml/ddl.sgml +++ b/doc/src/sgml/ddl.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.43 2005/08/12 01:35:53 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/ddl.sgml,v 1.44 2005/08/13 01:55:41 momjian Exp $ --> <chapter id="ddl"> <title>Data Definition</title> @@ -1122,6 +1122,17 @@ SELECT name, altitude support this <quote>ONLY</quote> notation. </para> + +<note> + <title>Inheritance and Permissions</title> + <para> + Because permissions are not inherited automatically a user attempting to access + a parent table must either have at least the same permission for the child table + or must use the <quote>ONLY</quote> notation. If creating a new inheritance + relationship in an existing system be careful that this does not create problems. + </para> +</note> + <note> <title>Deprecated</title> <para> |