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, 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

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

---(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

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 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