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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]