Skip site navigation (1) Skip section navigation (2)

Obsolete bits in docs for SQL-GRANT

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 (view raw or flat)
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

Responses

pgsql-patches by date

Next:From: Gregory StarkDate: 2007-07-27 17:17:21
Subject: Re: [HACKERS] Document and/or remove unreachable code in tuptoaster.c from varvarlena patch
Previous:From: Andrew DunstanDate: 2007-07-27 16:03:19
Subject: Re: [PATCHES] allow CSV quote in NULL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group