Excellent, thanks for the quick response. Greg On Dec 9, 2007 1:18 AM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > "Greg Steffensen" <greg.steffensen@xxxxxxxxx> writes: > > Hey, I'm slightly confused about how the permission checking is done > > when executing functions. Basically, users that I've never granted > > execution permissions to are able to execute functions. > > You didn't read the part of the GRANT man page that says that functions > have execute permissions granted to PUBLIC by default. > > You can revoke that if you don't like it. > > regards, tom lane > ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match