postgres.git / summary / log / commit / refs
commit 313d29f740ef92e25f2e7707c61697471d22ca1b
Author: Peter Eisentraut <peter_e@gmx.net>
Date: Sat Mar 17 08:34:00 2012 +0000
First released in: 9.2.0
Add note about column privilege behavior to REVOKE reference page
suggested by Josh Berkus
doc/src/sgml/ref/revoke.sgml | 2 ++
1 file changed, 2 insertions(+)
diff --git a/doc/src/sgml/ref/revoke.sgml b/doc/src/sgml/ref/revoke.sgml
index a390375c174..202a2a35ab4 100644
--- a/doc/src/sgml/ref/revoke.sgml
+++ b/doc/src/sgml/ref/revoke.sgml
@@ -162,6 +162,8 @@ REVOKE [ ADMIN OPTION FOR ]
<para>
When revoking privileges on a table, the corresponding column privileges
(if any) are automatically revoked on each column of the table, as well.
+ On the other hand, if a role has been granted privileges on a table, then
+ revoking the same privileges from individual columns will have no effect.
</para>
<para>
[parent: faec2815c8ea]