diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-02-14 03:32:14 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-02-14 03:32:14 +0000 |
| commit | 99b384b8b6f8268c2fdd103d398f12dcdb0934c2 (patch) | |
| tree | 8595a6380a6f40b00329e4bf4234793acf78ed1a | |
| parent | e93b33754c69d6cdc663f320ad9d31ac21112597 (diff) | |
| download | postgresql-99b384b8b6f8268c2fdd103d398f12dcdb0934c2.tar.gz postgresql-99b384b8b6f8268c2fdd103d398f12dcdb0934c2.zip | |
Document that GRANT on a table does not affect sequence permissions,
inclusing SERIAL column sequences.
| -rw-r--r-- | doc/src/sgml/ref/grant.sgml | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml index e5ea4bb144f..1ae5b480348 100644 --- a/doc/src/sgml/ref/grant.sgml +++ b/doc/src/sgml/ref/grant.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/grant.sgml,v 1.51 2006/01/21 02:16:18 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/grant.sgml,v 1.52 2006/02/14 03:32:14 momjian Exp $ PostgreSQL documentation --> @@ -376,6 +376,13 @@ GRANT <replaceable class="PARAMETER">role</replaceable> [, ...] </para> <para> + Granting permission on a table does not automatically extend + permissions to any sequences used by the table, including + sequences tied to <type>SERIAL</> columns. Permissions on + sequence must be set separately. + </para> + + <para> Currently, <productname>PostgreSQL</productname> does not support granting or revoking privileges for individual columns of a table. One possible workaround is to create a view having just the desired |