Re: How to restrict select from table with external validation?

From: "Vladimir A(dot) Petrov" <vap(at)infopac(dot)ru>
To: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to restrict select from table with external validation?
Date: 2006-07-12 08:22:04
Message-ID: 44B4B12C.4020400@infopac.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Sean Davis пишет:

> You could create another function that returns a set of rows from stats.
> That function could check the auth function and then select only those

Right that way I solved my problem yesterday. Another one important
thing is to set 'SECURITY DEFINER' attribute in function definition.

Thank you!
--
Vladimir A. Petrov (aka vap) phone: (+7 8482) 420069
Infopac JSC. Head of the exploitation department. http://infopac.ru
_______________________________________________________________________
^[:wq ...sed libera nos a malo.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ilias Goudaropoulos 2006-07-12 08:46:55 Installer errors on WinXP SP2
Previous Message Andrej Ricnik-Bay 2006-07-11 21:10:23 Re: Data Types and Their Aliases