From: | Erwin Brandstetter <brandstetter(at)falter(dot)at> |
---|---|
To: | pgsql-patches(at)postgresql(dot)org |
Subject: | Obsolete bits in docs for SQL-GRANT |
Date: | 2007-07-27 16:17:19 |
Message-ID: | 46AA1A8F.4090700@falter.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
Concerning the docs at
http://www.postgresql.org/docs/8.2/static/sql-grant.html
Obviously for historical reasons the syntax in a number of places still
reads
" /username/ | GROUP /groupname/"
instead of
" //[GROUP] /role//name/"
(Allthough I would change that.)
However, the example further down is not correct any more:
Schema | Name | Type | Access privileges
--------+---------+-------+-----------------------------------------------------------
public | mytable | table | {miriam=arwdxt/miriam,=r/miriam,"group
todos=arw/miriam"}
There is not "group" in the ACL list any more (at least I don't see it
in my 8.1 or 8.2 databases). It should read:
Schema | Name | Type | Access privileges
--------+---------+-------+-----------------------------------------------------------
public | mytable | table |
{miriam=arwdxt/miriam,=r/miriam,todos=arw/miriam}
Also, I suppose to substitute
uname=xxxx -- privileges granted to a user
group gname=xxxx -- privileges granted to a group
with
rname=xxxx -- privileges granted to a role
Regards
Erwin
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2007-07-27 17:17:21 | Re: [HACKERS] Document and/or remove unreachable code in tuptoaster.c from varvarlena patch |
Previous Message | Andrew Dunstan | 2007-07-27 16:03:19 | Re: [PATCHES] allow CSV quote in NULL |