Discrpency in the GRANT docs

From: Erik Jones <erik(at)myemma(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Discrpency in the GRANT docs
Date: 2007-11-29 17:05:56
Message-ID: 628E5B22-66A7-456E-B495-3FB8C66EEA44@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I just noticed this. In the section of the page, near the end, that
describes the access privileges display generated by psql's \z (which
come from pg_class.relacl) there is the following:

/yyyy -- user who granted this privilege

That's not the case. What get's listed there is the current owner of
the table (at least in 8.2). So, then the question is are the docs
correct or is the behavior correct ? Here's a test run:

usda=# select current_user;
current_user
--------------
admin
(1 row)

usda=# create table test (id integer);
CREATE TABLE
usda=# create role test_user1;
CREATE ROLE
usda=# create role test_user2;
CREATE ROLE
usda=# \z test
Access privileges for database "usda"
Schema | Name | Type | Access privileges
--------+------+-------+-------------------
public | test | table |
(1 row)

usda=# grant all on test to test_user1;
GRANT
usda=# \z test
Access privileges for database "usda"
Schema | Name | Type | Access privileges
--------+------+-------+----------------------------------------------
public | test | table | {admin=arwdxt/admin,test_user1=arwdxt/admin}
(1 row)

usda=# alter table test owner to test_user2;
ALTER TABLE
usda=# \z test
Access privileges for database "usda"
Schema | Name | Type | Access privileges
--------+------+-------
+-------------------------------------------------------------
public | test | table | {test_user2=arwdxt/
test_user2,test_user1=arwdxt/test_user2}
(1 row)

usda=# alter table test owner to admin;
ALTER TABLE
usda=# \z test
Access privileges for database "usda"
Schema | Name | Type | Access privileges
--------+------+-------+----------------------------------------------
public | test | table | {admin=arwdxt/admin,test_user1=arwdxt/admin}
(1 row)

Erik Jones

Software Developer | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2007-11-29 17:19:41 Re: Error compiling Slony I
Previous Message Joshua D. Drake 2007-11-29 17:04:30 Re: HD is flooded by Error Log info