Skip to content

Commit 8e0f863

Browse files
committed
Remove example of SQL-standard syntax for GRANT/REVOKE --- was causing
confusion.
1 parent 5f3fbe1 commit 8e0f863

File tree

2 files changed

+6
-19
lines changed

2 files changed

+6
-19
lines changed

doc/src/sgml/ref/grant.sgml

Lines changed: 3 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/grant.sgml,v 1.64 2007/02/01 00:28:19 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/grant.sgml,v 1.65 2007/04/07 03:48:25 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -520,14 +520,8 @@ GRANT admins TO joe;
520520
</para>
521521

522522
<para>
523-
The SQL standard allows setting privileges for individual columns
524-
within a table:
525-
526-
<synopsis>
527-
GRANT <replaceable class="PARAMETER">privileges</replaceable>
528-
ON <replaceable class="PARAMETER">table</replaceable> [ ( <replaceable class="PARAMETER">column</replaceable> [, ...] ) ] [, ...]
529-
TO { PUBLIC | <replaceable class="PARAMETER">username</replaceable> [, ...] } [ WITH GRANT OPTION ]
530-
</synopsis>
523+
<productname>PostgreSQL</productname> does not support the SQL-standard
524+
functionality of setting privileges for individual columns.
531525
</para>
532526

533527
<para>

doc/src/sgml/ref/revoke.sgml

Lines changed: 3 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/revoke.sgml,v 1.42 2007/01/31 23:26:04 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/revoke.sgml,v 1.43 2007/04/07 03:48:25 momjian Exp $
33
PostgreSQL documentation
44
-->
55

@@ -231,15 +231,8 @@ REVOKE admins FROM joe;
231231

232232
<para>
233233
The compatibility notes of the <xref linkend="sql-grant" endterm="sql-grant-title"> command
234-
apply analogously to <command>REVOKE</command>. The syntax summary is:
235-
236-
<synopsis>
237-
REVOKE [ GRANT OPTION FOR ] <replaceable class="PARAMETER">privileges</replaceable>
238-
ON <replaceable class="parameter">object</replaceable> [ ( <replaceable class="parameter">column</replaceable> [, ...] ) ]
239-
FROM { PUBLIC | <replaceable class="parameter">username</replaceable> [, ...] }
240-
{ RESTRICT | CASCADE }
241-
</synopsis>
242-
One of <literal>RESTRICT</literal> or <literal>CASCADE</literal>
234+
apply analogously to <command>REVOKE</command>.
235+
<literal>RESTRICT</literal> or <literal>CASCADE</literal>
243236
is required according to the standard, but <productname>PostgreSQL</>
244237
assumes <literal>RESTRICT</literal> by default.
245238
</para>

0 commit comments

Comments
 (0)