Permissions and views.

Hello,
I am having this little annoying problem with permisions - there is a
table, with 'select' permision, and then there is a view with ALL
permisions on it.
When I update the view, I get 'permision denied' at source table, unless
I'm using user with ability to create databases/users.

>From logs:
010504.12:27:31.774 [2179] ProcessQuery
010504.12:27:31.779 [2179] query: SELECT oid FROM "jednostka" WHERE
"brcd" = $1 FOR UPDATE OF "jednostka"
010504.12:27:31.780 [2179] parser outputs:
010504.12:27:31.784 [2179] ERROR: jednostka: Permission denied.

but select oid FROM "jednostka" where "brcd" = 222; works fine. for
update clause makes the difference.

What's wrong?

--
xx xxx...
Dariusz Pietrzak http://eyck.tinet.pl
Eyck(at)irc(dot)pl dariush(at)ajax(dot)umcs(dot)lublin(dot)pl