Re: [HACKERS] In which module does query rewriting takes place
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, the missing piece is that case is "row level". cheers andrew ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] In which module does query rewriting takes place
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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] In which module does query rewriting takes place
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 there about the existing access controls that does not do what you want? cheers andrew ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org