Re: [HACKERS] In which module does query rewriting takes place

2006-10-02 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: Shaunak Godbole wrote: We are trying to introduce access control. This sounds like a pretty ugly hack. Perhaps more to the point, it's already been done: http://veil.projects.postgresql.org/ Ah

Re: [HACKERS] In which module does query rewriting takes place

2006-10-02 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > Shaunak Godbole wrote: >> We are trying to introduce access control. > This sounds like a pretty ugly hack. Perhaps more to the point, it's already been done: http://veil.projects.postgresql.org/ regards, tom lane

Re: [HACKERS] In which module does query rewriting takes place

2006-10-02 Thread Andrew Dunstan
Shaunak Godbole wrote: Hi, We are trying to introduce access control. For this we have to rewrite the input query by replacing each relation by its corresponding authorized view. This sounds like a pretty ugly hack. There are already extensive access controls available in postgres. What is