diff options
| author | Bruce Momjian <bruce@momjian.us> | 2007-04-07 03:48:25 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2007-04-07 03:48:25 +0000 |
| commit | 8e0f8630a64e6b3ab239053f1eaa554ec1b59d3f (patch) | |
| tree | 15439ee590e39abd6f03458f6bc857c189bfabd1 | |
| parent | 5f3fbe14f3593a76a677414cf3ab4b64f60a8f35 (diff) | |
| download | postgresql-8e0f8630a64e6b3ab239053f1eaa554ec1b59d3f.tar.gz postgresql-8e0f8630a64e6b3ab239053f1eaa554ec1b59d3f.zip | |
Remove example of SQL-standard syntax for GRANT/REVOKE --- was causing
confusion.
| -rw-r--r-- | doc/src/sgml/ref/grant.sgml | 12 | ||||
| -rw-r--r-- | doc/src/sgml/ref/revoke.sgml | 13 |
2 files changed, 6 insertions, 19 deletions
diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml index 080df2b044a..a4c3b0d4408 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.64 2007/02/01 00:28:19 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/grant.sgml,v 1.65 2007/04/07 03:48:25 momjian Exp $ PostgreSQL documentation --> @@ -520,14 +520,8 @@ GRANT admins TO joe; </para> <para> - The SQL standard allows setting privileges for individual columns - within a table: - -<synopsis> -GRANT <replaceable class="PARAMETER">privileges</replaceable> - ON <replaceable class="PARAMETER">table</replaceable> [ ( <replaceable class="PARAMETER">column</replaceable> [, ...] ) ] [, ...] - TO { PUBLIC | <replaceable class="PARAMETER">username</replaceable> [, ...] } [ WITH GRANT OPTION ] -</synopsis> + <productname>PostgreSQL</productname> does not support the SQL-standard + functionality of setting privileges for individual columns. </para> <para> diff --git a/doc/src/sgml/ref/revoke.sgml b/doc/src/sgml/ref/revoke.sgml index caf62b78331..412da611e2d 100644 --- a/doc/src/sgml/ref/revoke.sgml +++ b/doc/src/sgml/ref/revoke.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/revoke.sgml,v 1.42 2007/01/31 23:26:04 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/revoke.sgml,v 1.43 2007/04/07 03:48:25 momjian Exp $ PostgreSQL documentation --> @@ -231,15 +231,8 @@ REVOKE admins FROM joe; <para> The compatibility notes of the <xref linkend="sql-grant" endterm="sql-grant-title"> command - apply analogously to <command>REVOKE</command>. The syntax summary is: - -<synopsis> -REVOKE [ GRANT OPTION FOR ] <replaceable class="PARAMETER">privileges</replaceable> - ON <replaceable class="parameter">object</replaceable> [ ( <replaceable class="parameter">column</replaceable> [, ...] ) ] - FROM { PUBLIC | <replaceable class="parameter">username</replaceable> [, ...] } - { RESTRICT | CASCADE } -</synopsis> - One of <literal>RESTRICT</literal> or <literal>CASCADE</literal> + apply analogously to <command>REVOKE</command>. + <literal>RESTRICT</literal> or <literal>CASCADE</literal> is required according to the standard, but <productname>PostgreSQL</> assumes <literal>RESTRICT</literal> by default. </para> |