I dont know if I do something wrong or it is normal for PG :)
So
template1=# select version();
version
-
PostgreSQL 7.0.3 on i486-pc-linux-gnu, compiled by gcc egcs-2.91.66
(1 row)
And now:
Ok... I found bug, it was me ;)))
In some strange moment I add this tables to template1 instead of
test. Maybe I must go sleep more ;)).
regards
Robert
I dont know if I do something wrong or it is normal for PG :)
So
template1=# select version();
version
Hello,
Merry Christmass and Happy New Year 2001 ;)
R. "BoBsoN" Partyka
On Fri, 22 Dec 2000, Rod Taylor wrote:
Little early aren't you?
I live from town (and this meen no internet access) today
and when I back will be the XXI century so its last
chance to wish You all mery xmass and happy new year ;)
So have a good party at night 31.12.2000, dont drink to
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
Partyka Robert [EMAIL PROTECTED] writes:
#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
Hi
Yeach ... I can revoke from public now ;), but .
look at this:
#create database a
CREATE
#\c a
#create table ala(a int4);
CREATE
#\z
Access permissions for database "a"
Relation | Access permissions
--+
ala |
(1 row)
#revoke all on ala from public;