Permissions and views.
От | Dariusz Pietrzak |
---|---|
Тема | Permissions and views. |
Дата | |
Msg-id | Pine.LNX.4.10.10105041400110.19243-100000@ajax.umcs.lublin.pl обсуждение исходный текст |
Ответ на | Re: DBD::Pg errstr method doesn't return full error messages ("Peter Haworth" <pmh@edison.ioppublishing.com>) |
Ответы |
Re: Permissions and views.
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: