Commit8e0f863

committed

Remove example of SQL-standard syntax for GRANT/REVOKE --- was causing

confusion.

1 parent5f3fbe1 commit8e0f863Copy full SHA for 8e0f863

File tree

-19

lines changed

-19

lines changed

Lines changed: 3 additions & 9 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`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 $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -520,14 +520,8 @@ GRANT admins TO joe;`
`520`	`520`	`</para>`
`521`	`521`
`522`	`522`	`<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.`
`531`	`525`	`</para>`
`532`	`526`
`533`	`527`	`<para>`

Lines changed: 3 additions & 10 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,5 +1,5 @@`
`1`	`1`	`<!--`
`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 $`
`3`	`3`	`PostgreSQL documentation`
`4`	`4`	`-->`
`5`	`5`
`@@ -231,15 +231,8 @@ REVOKE admins FROM joe;`
`231`	`231`
`232`	`232`	`<para>`
`233`	`233`	`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>`
`243`	`236`	`is required according to the standard, but <productname>PostgreSQL</>`
`244`	`237`	`assumes <literal>RESTRICT</literal> by default.`
`245`	`238`	`</para>`

Comments

(0)