| 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: | Whole Thread | Raw Message | 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
| 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 |