Re: How do I revoke CREATE TABLE and other privileges?

On Thu, Jul 06, 2006 at 09:55:40AM -0700, John Purser wrote:
> "Karen Hill" <karen_hill22@yahoo.com> 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