Re: FW: GRANT question

On Sat, Nov 26, 2005 at 09:37:00PM +0100, Egyd Csaba (Freemail) wrote:
> moson.gdb=> SELECT oid::regprocedure FROM pg_proc WHERE proname ILIKE
> '%eden%';
[...]
> public.edenproc_usesysid(text)

Hmmm...so the function indeed exists in the public schema. What
happens if you call the schema-qualified function? What are the
permissions on the schema itself?

SELECT public.edenproc_usesysid('probauser');
SELECT * FROM pg_namespace WHERE nspname = 'public';

If the first query fails with "permission denied for schema public"
then you probably need to grant at least USAGE on the public schema
to certain users. That would imply that somebody has changed the
default permissions on public, either in this database or in the
template datbase from which it was created (template1 by default).

--
Michael Fuhr