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

Commit99b384b

Browse files
committed
Document that GRANT on a table does not affect sequence permissions,
inclusing SERIAL column sequences.
1 parente93b337 commit99b384b

File tree

1 file changed

+8
-1
lines changed

1 file changed

+8
-1
lines changed

‎doc/src/sgml/ref/grant.sgml

Lines changed: 8 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/grant.sgml,v 1.51 2006/01/21 02:16:18 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/grant.sgml,v 1.52 2006/02/14 03:32:14 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -375,6 +375,13 @@ GRANT <replaceable class="PARAMETER">role</replaceable> [, ...]
375375
specific role you want to do the <command>GRANT</> as.
376376
</para>
377377

378+
<para>
379+
Granting permission on a table does not automatically extend
380+
permissions to any sequences used by the table, including
381+
sequences tied to <type>SERIAL</> columns. Permissions on
382+
sequence must be set separately.
383+
</para>
384+
378385
<para>
379386
Currently, <productname>PostgreSQL</productname> does not support
380387
granting or revoking privileges for individual columns of a table.

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp