Skip site navigation (1) Skip section navigation (2)

postgres not use table access permissions ?

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 (view raw or flat)
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


Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2000-11-03 18:02:22
Subject: Re: Re: [COMMITTERS] pgsql/contrib/pg_dumpaccounts (Makefile README pg_dumpaccounts.sh)
Previous:From: Peter EisentrautDate: 2000-11-03 17:49:42
Subject: Re: Re: [COMMITTERS] pgsql/contrib/pg_dumpaccounts (Makefile README pg_dumpaccounts.sh)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group