diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2003-01-10 11:02:51 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2003-01-10 11:02:51 +0000 |
| commit | 36ea26793a14d016059de2f1c83a05cf87a8bb92 (patch) | |
| tree | fa40574afa8e64cacf5e1d1e60845d1da015ad9d /doc/src | |
| parent | 611278cc0b78421f634007a573f178eb9acd7550 (diff) | |
Add optional drop behavior clause to REVOKE command, for SQL conformance.
Currently, only RESTRICT is allowed.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/features.sgml | 14 | ||||
| -rw-r--r-- | doc/src/sgml/ref/revoke.sgml | 12 |
2 files changed, 18 insertions, 8 deletions
diff --git a/doc/src/sgml/features.sgml b/doc/src/sgml/features.sgml index 30f20bf51e4..fd01cd3cce6 100644 --- a/doc/src/sgml/features.sgml +++ b/doc/src/sgml/features.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.12 2002/12/14 00:24:23 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.13 2003/01/10 11:02:41 petere Exp $ --> <appendix id="features"> @@ -741,6 +741,12 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.12 2002/12/14 00:24:23 pe <entry></entry> </row> <row> + <entry>F031-19</entry> + <entry>Core</entry> + <entry>REVOKE statement: RESTRICT clause</entry> + <entry></entry> + </row> + <row> <entry>F032</entry> <entry></entry> <entry>CASCADE drop behavior</entry> @@ -1630,12 +1636,6 @@ $Header: /cvsroot/pgsql/doc/src/sgml/features.sgml,v 2.12 2002/12/14 00:24:23 pe <entry></entry> </row> <row> - <entry>F031-19</entry> - <entry>Core</entry> - <entry>REVOKE statement: RESTRICT clause</entry> - <entry></entry> - </row> - <row> <entry>F034</entry> <entry></entry> <entry>Extended REVOKE statement</entry> diff --git a/doc/src/sgml/ref/revoke.sgml b/doc/src/sgml/ref/revoke.sgml index 2b8334d3ee9..345024bb7cc 100644 --- a/doc/src/sgml/ref/revoke.sgml +++ b/doc/src/sgml/ref/revoke.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/revoke.sgml,v 1.23 2002/11/21 23:34:43 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/revoke.sgml,v 1.24 2003/01/10 11:02:51 petere Exp $ PostgreSQL documentation --> @@ -20,22 +20,27 @@ REVOKE { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,...] | ALL [ PRIVILEGES ] } ON [ TABLE ] <replaceable class="PARAMETER">tablename</replaceable> [, ...] FROM { <replaceable class="PARAMETER">username</replaceable> | GROUP <replaceable class="PARAMETER">groupname</replaceable> | PUBLIC } [, ...] + [ RESTRICT ] REVOKE { { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] } ON DATABASE <replaceable>dbname</replaceable> [, ...] FROM { <replaceable class="PARAMETER">username</replaceable> | GROUP <replaceable class="PARAMETER">groupname</replaceable> | PUBLIC } [, ...] + [ RESTRICT ] REVOKE { EXECUTE | ALL [ PRIVILEGES ] } ON FUNCTION <replaceable>funcname</replaceable> ([<replaceable>type</replaceable>, ...]) [, ...] FROM { <replaceable class="PARAMETER">username</replaceable> | GROUP <replaceable class="PARAMETER">groupname</replaceable> | PUBLIC } [, ...] + [ RESTRICT ] REVOKE { USAGE | ALL [ PRIVILEGES ] } ON LANGUAGE <replaceable>langname</replaceable> [, ...] FROM { <replaceable class="PARAMETER">username</replaceable> | GROUP <replaceable class="PARAMETER">groupname</replaceable> | PUBLIC } [, ...] + [ RESTRICT ] REVOKE { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] } ON SCHEMA <replaceable>schemaname</replaceable> [, ...] FROM { <replaceable class="PARAMETER">username</replaceable> | GROUP <replaceable class="PARAMETER">groupname</replaceable> | PUBLIC } [, ...] + [ RESTRICT ] </synopsis> </refsynopsisdiv> @@ -63,6 +68,11 @@ REVOKE { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] } See the description of the <xref linkend="sql-grant" endterm="sql-grant-title"> command for the meaning of the privilege types. </para> + + <para> + The <literal>RESTRICT</literal> key word is currently only noise. + See also the compatibility notes below. + </para> </refsect1> <refsect1 id="SQL-REVOKE-notes"> |