Strange security behaviour!

Hello to all,

Currently I'm using version 7.1

I got a strange security behaviour. Please find attached my init.sql script
for my tables:

>psql -d test -U admin -c "\dp entry_t"
Access permissions for database "test"
Relation    |                   Access permissions
----------------+---------------------------------------------------------
entry_t        | {"=","csczeyka=arwR","admin=arw","anonym=r","helper=r"}
entry_t_id_seq |
(2 rows)

>psql -d test -U admin -c "\d entry_t"
Table "entry_t"
Attribute  |  Type   |                      Modifier
------------+---------+----------------------------------------------------
id         | integer | not null default nextval('"entry_t_id_seq"'::text)
ent_seq    | integer |
upd_date   | date    | not null
upd_txt    | text    |
upd_author | integer |
chk_date   | date    | not null
chk_txt    | text    |
chk_author | integer |
Index: entry_t_pkey


Basically, now "admin" can insert new rows into "entry_t", but not "anonym"
or "helper". So let's see:

>psql -d test -U admin -c "INSERT INTO entry_t (upd_date, chk_date) VALUES
>(CURRENT_DATE, CURRENT_DATE);"
ERROR:  entry_t_id_seq.nextval: you don't have permissions to set sequence
entry_t_id_seq

upsy???

>psql -d test -U helper -c "INSERT INTO entry_t (upd_date, chk_date) VALUES
>(CURRENT_DATE , CURRENT_DATE);"
INSERT 1861619 1

upsy??????????

>psql -d test -U anonym -c "INSERT INTO entry_t (upd_date, chk_date) VALUES
>(CURRENT_DATE
, CURRENT_DATE);"
ERROR:  entry_t: Permission denied.

finally this  is okay.

I just wonder, what is the DBs behaviour on your system?

I hope it's just a stupid beginners fault.

ThX for helping,
Chris (lotuslubyloo@---no-spam---hotmail.com)
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.