Obsolete bits in docs for SQL-GRANT

Lists: pgsql-patches
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
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: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Erwin Brandstetter <brandstetter(at)falter(dot)at>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: Obsolete bits in docs for SQL-GRANT
Date: 2007-10-30 19:44:44
Message-ID: 27117.1193773484@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-patches

Erwin Brandstetter <brandstetter(at)falter(dot)at> writes:
> 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.)

Right, done.

> However, the example further down is not correct any more:

Fixed --- thanks for reporting it!

regards, tom lane