On Thu, Jul 06, 2006 at 09:55:40AM -0700, John Purser wrote: > "Karen Hill" <karen_hill22@xxxxxxxxx> wrote: > > Revoking PUBLIC worked. I can now login to the database and it will > > not allow me to create new tables. However when I gave (as postgres) > > the restricted user permission to execute one function it says it > > cannot find the function when I try to execute it. > > You hopefully just need to edit your search path. See page 56 of the > manual for details. Type 'show search_path;' into pgsql and see what > the value is currently set to. Then use set to make it include the > schema with your function. The user probably needs USAGE on the schema. If a user has no privileges on a schema then he or she can't access objects in that schema regardless of search_path or the privileges on the objects themselves. -- Michael Fuhr
