Hello
PostgreSQL doesn't run procedures with owner rights, but with caller
rights. If you would to change this behave, then you have to set
SECURITY DEFINER flag for procedure.
regards
Pavel Stehule
2009/7/14 Aleksandr Peshcherskikh :
> Hello support team!
> I wanna do next trick. Create user an
Hello support team!
I wanna do next trick. Create user and deny access on tables to him but
allow to execute stored procedures which are referenced to the denied data.
It's very ordinary use case. But I don't know how to do it in postgresql (if
it is possible of course)
I tried the next way.
1. cre
