Hi Jonathan. Good article - however, I have run into a hitch.
I'm trying to use table functions to encapsulate logic for re-use.
If the signed procedure accesses the tables directly, the certificate and the certificate user allow this to occur.
However, you can't sign a table function, and a procedure which calls a table function which then selects from the table... no joy here either.
It's like the security link between the procedure and the user is lost in translation.
Can you tell me if I'm on a no hoper here? Or is there a way to do this?