Re: Permissions within a function

Thomas Hallgren <thhal@mailblocks.com> writes:
> Peter Eisentraut wrote:
>> You can use GetUserId() and SetUserId() to flip the current user 
>> identity around as you like.  For such a simple query, however, it 
>> might seem better to bypass SPI altogether and do a straight table 
>> lookup through lower-level functions.
>> 
> Brilliant! I had no idea it was that simple.

Well, it's not.  Exactly what are you going to flip it *to*?  You can't
hardwire a particular userid and expect to have a robust solution.

I'd recommend the lower-level approach myself.
        regards, tom lane