From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | "Hackers" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Another nasty pg_dump problem |
Date: | 2003-07-09 03:06:17 |
Message-ID: | 09be01c345c7$114970e0$2800a8c0@mars |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On my 7.3 server:
australia=# \dp exercise_activities
Access privileges for database "australia"
Schema | Table | Access privileges
--------+---------------------+---------------------------------------------
------------
public | exercise_activities |
{=,chriskl=arwdRxt,auadmin=arwdRxt,au-diary=r,au-php=r}
(1 row)
is dumped as:
REVOKE ALL ON TABLE exercise_activities FROM PUBLIC;
GRANT ALL ON TABLE exercise_activities TO chriskl;
GRANT SELECT ON TABLE exercise_activities TO "au-diary";
GRANT SELECT ON TABLE exercise_activities TO "au-php";
Now if you load that into 7.4CVS, you get:
australia=# \dp exercise_activities
Access privileges for
database "australia"
Schema | Table |
Access privileges
--------+---------------------+---------------------------------------------
-------------------------------------------------------------
public | exercise_activities |
{auadmin=a*r*w*d*R*x*t*/auadmin,chriskl=arwdRxt/auadmin,"\"au-diary\"=r/auad
min","\"au-php\"=r/auadmin"}
(1 row)
Which is dumped as:
REVOKE ALL ON TABLE exercise_activities FROM PUBLIC;
GRANT ALL ON TABLE exercise_activities TO chriskl;
GRANT SELECT ON TABLE exercise_activities TO "\""au-diary\""";
GRANT SELECT ON TABLE exercise_activities TO "\""au-php\""";
ie. 7.4 considers the double quotes around a username to be part of the
username...
Chris
From | Date | Subject | |
---|---|---|---|
Next Message | subbiah K | 2003-07-09 05:06:08 | postgres security |
Previous Message | Christopher Kings-Lynne | 2003-07-09 01:58:47 | Re: Bad permissions bug in 7.3 dump (and 7.4)? |