Re: PostGres Doubt

My apologies, I was too brief in my example:

heakin=> create table interviewers ( interviewer varchar );
CREATE
heakin=> insert into interviewers values ('Ryan');
INSERT 932846 1
heakin=> select * from interviewers ;interviewer
-------------Ryan
(1 row)

heakin=> \z
Access privileges for database "heakin"      Table       | Access privileges
-------------------+-------------------clients           | {=,heakin=arwd}completed_surveys |
{=,heakin=arwd}interviewers     |respondents       | {=,heakin=arwd}users             | {=,heakin=ar}
 
(5 rows)

heakin=> grant select,insert,update on interviewers to heakin;
GRANT
heakin=> \z
Access privileges for database "heakin"      Table       | Access privileges 
-------------------+--------------------clients           | {=,heakin=arwd}completed_surveys |
{=,heakin=arwd}interviewers     | {=,heakin=arwdRxt}respondents       | {=,heakin=arwd}users             |
{=,heakin=ar}
(5 rows)

heakin=> revoke all on interviewers from heakin;
REVOKE
heakin=> \z
Access privileges for database "heakin"      Table       | Access privileges
-------------------+-------------------clients           | {=,heakin=arwd}completed_surveys |
{=,heakin=arwd}interviewers     | {=}respondents       | {=,heakin=arwd}users             | {=,heakin=ar}
 
(5 rows)

heakin=> grant select,insert,update on interviewers to heakin;
GRANT
heakin=> \z
Access privileges for database "heakin"      Table       | Access privileges
-------------------+-------------------clients           | {=,heakin=arwd}completed_surveys |
{=,heakin=arwd}interviewers     | {=,heakin=arw}respondents       | {=,heakin=arwd}users             | {=,heakin=ar}
 
(5 rows)

David

Tom Lane wrote:

>David Ford <david+cert@blue-labs.org> writes:
>  
>
>>Which btw has a curious grant/revoke bug.  create foo; grant select on 
>>foo to bar; results in all rights being granted.  You must revoke and 
>>grant again in order to get the correct rights set.
>>    
>>
>
>I see no bug.
>
>test72=# select version();
>                            version
>---------------------------------------------------------------
> PostgreSQL 7.2.1 on hppa-hp-hpux10.20, compiled by GCC 2.95.3
>(1 row)
>
>test72=# create user bar;
>CREATE USER
>test72=# create table foo (f1 int);
>CREATE
>test72=# grant select on foo to bar;
>GRANT
>test72=# \z foo
>Access privileges for database "test72"
> Table |     Access privileges
>-------+----------------------------
> foo   | {=,postgres=arwdRxt,bar=r}
>(1 row)
>
>test72=#
>
>            regards, tom lane
>  
>