On Thu, Oct 2, 2008 at 8:07 PM, Vivek Khera <vivek at khera.org> wrote:

> > Before I issue a GRANT to allow select rights on that table to anyone
> > who tries, my questions are:
> > * Is there any inherent danger in allowing SELECT on that table to
> >  normal users?
> > * Is there a better way (I looked for a store procedure, such as
> >  getlocalnodeid(), but if it exists, I'm not seeing it in the docs)
>
> Can't you define a function that does that query and returns
> true/false as necessary, and is declared as SECURITY DEFINER so that
> it runs with sufficient privileges?
>

That actually sounds like a plan... +1

-- =

gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com

EnterpriseDB      http://www.enterprisedb.com

Mail sent from my BlackLaptop device
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20081002/=
858f2955/attachment.htm