Thread: Obsolete bits in docs for SQL-GRANT

Obsolete bits in docs for SQL-GRANT

From
Erwin Brandstetter
Date:
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

Re: Obsolete bits in docs for SQL-GRANT

From
Tom Lane
Date:
Erwin Brandstetter <brandstetter@falter.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