Hello to all,

Currently I'm using version 7.1

I got a strange security behaviour. Please find attached my init 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 yur system?

I hope it's just a stupid beginners fault.

ThX for helping me out,
Chris
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.