| From: | Partyka Robert <bobson(at)saturn(dot)alpha(dot)pl> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | postgres not use table access permissions ? |
| Date: | 2000-11-03 17:57:43 |
| Message-ID: | Pine.LNX.4.21.0011031847360.22116-100000@saturn.alpha.pl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
I start yesterday CVS PostgreSQL server, and saw strange thing:
from user postgres:
# create database test;
CREATE
# \c test;
#create user bobson with password '1' nocreatedb nocreateuser;
CREATE
#create table a (a int4);
CREATE
#revoke all on a from public;
CHANGE
and now from user bobson after conecting to test database:
#insert into a values ('1');
INSERT 19104 1
hmmm... looks like bug. Or I miss something?
so next from user postgres:
#revoke all on a from bobson;
CHANGE
and from user bobson after connect:
#delete from a;
DELETE 1
Postgres ignore access permissions ?
BTW... in my pg_hba.conf
local password
...
regards
Robert 'BoBsoN' Partyka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2000-11-03 18:02:22 | Re: Re: [COMMITTERS] pgsql/contrib/pg_dumpaccounts (Makefile README pg_dumpaccounts.sh) |
| Previous Message | Peter Eisentraut | 2000-11-03 17:49:42 | Re: Re: [COMMITTERS] pgsql/contrib/pg_dumpaccounts (Makefile README pg_dumpaccounts.sh) |