bug

From: Victor Vislobokov <victor_v(at)permonline(dot)ru>
To: bugs(at)postgresql(dot)org
Subject: bug
Date: 1999-08-12 17:30:11
Message-ID: 37B304A3.1227F965@permonline.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello!

I'm sorry for my bad English.

I found a bug with user rights.

Situation:

CREATE TABLE kaka;
CREATE USER baka;
GRANT SELECT ON kaka TO baka;
SELECT relname, relacl FROM pg_class WHERE relname='kaka';

relname|relacl
-------+---------------
kaka |{"=","baka=r"}

DROP USER baka;
SELECT relname, relacl FROM pg_class WHERE relname='kaka';

relname|relacl
-------+---------------
kaka |{"=","33=r"}
^^^- Wow! Why?

CREATE USER abc;
SELECT relname, relacl FROM pg_class WHERE relname='kaka';

relname|relacl
-------+---------------
kaka |{"=","abc=r"}

Wait, wait... I don't make access to user 'abc'.
User 'abc' got access to table kaka AUTOMATICALY!

With best wishes,
Victor Vislobokov
Perm, Russia

Browse pgsql-bugs by date

  From Date Subject
Next Message Mark Dalphin 1999-08-13 22:57:23 UNIQUE constraint no longer works under 6.5.1
Previous Message Giampiero Raschetti 1999-08-12 15:44:54 GROUP BY bug report