Re: GRANT question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Együd Csaba <csegyud(at)vnet(dot)hu>, pgsql-general(at)postgresql(dot)org
Subject: Re: GRANT question
Date: 2005-11-26 23:07:06
Message-ID: 20059.1133046426@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Fuhr <mike(at)fuhr(dot)org> writes:
> Oops, I forgot that \df uses pg_function_is_visible(), so it won't
> show functions that aren't in your search path. Try this:

Or try
\df *.edenproc_usesysid

I note the lack of "show search_path" for the non-admin user in
your example ... it might also be interesting to try
select current_schemas(true);

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Együd Csaba 2005-11-27 06:51:49 Re: GRANT question
Previous Message Michael Fuhr 2005-11-26 21:15:58 Re: FW: GRANT question