Re: Permissions within a function

Thomas Hallgren wrote:
> Is there a way to bypass security checks that retains the SQL parser?
> I'd like my C-code to do something like:
>
> impersonate pgadmin
> SELECT image from class_table
> revert to self

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.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/