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@irc.pl dariush@ajax.umcs.lublin.pl
