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

[HACKERS] In which module does query rewriting takes place

2006-10-02 Thread Shaunak Godbole
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. Which part of the code should we modify for this. Till now we have thought of the following: 1. We take as input the parse tree generated by the