From 8e0f8630a64e6b3ab239053f1eaa554ec1b59d3f Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 7 Apr 2007 03:48:25 +0000 Subject: [PATCH] Remove example of SQL-standard syntax for GRANT/REVOKE --- was causing confusion. --- doc/src/sgml/ref/grant.sgml | 12 +++--------- 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 @@ @@ -520,14 +520,8 @@ GRANT admins TO joe; - The SQL standard allows setting privileges for individual columns - within a table: - - -GRANT privileges - ON table [ ( column [, ...] ) ] [, ...] - TO { PUBLIC | username [, ...] } [ WITH GRANT OPTION ] - + PostgreSQL does not support the SQL-standard + functionality of setting privileges for individual columns. 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 @@ @@ -231,15 +231,8 @@ REVOKE admins FROM joe; The compatibility notes of the command - apply analogously to REVOKE. The syntax summary is: - - -REVOKE [ GRANT OPTION FOR ] privileges - ON object [ ( column [, ...] ) ] - FROM { PUBLIC | username [, ...] } - { RESTRICT | CASCADE } - - One of RESTRICT or CASCADE + apply analogously to REVOKE. + RESTRICT or CASCADE is required according to the standard, but PostgreSQL assumes RESTRICT by default. -- 2.39.5