Postgres Pro
Downloads
Home   >   mailing lists

Re: the "users" group and restricting privileges - Mailing list pgsql-admin

From Tom Lane
Subject Re: the "users" group and restricting privileges
Date
Msg-id 11392.1133310091@sss.pgh.pa.us
Whole thread Raw
In response to the "users" group and restricting privileges  (Dan Tenenbaum <dandante@gmail.com>)
Responses Re: the "users" group and restricting privileges
List pgsql-admin
Tree view 
Dan Tenenbaum <dandante@gmail.com> writes:
> ERROR: permission denied for schema myschema
> What do I need to do to get the correct permissions?

GRANT USAGE ON SCHEMA myschema TO whoever

Schema access is comparable to directory access in a filesystem: if you
can't look into the directory, it doesn't matter what privileges you
might have for the individual files in it.

            regards, tom lane

pgsql-admin by date:

Previous
From: Dan Tenenbaum
Date:
Subject: the "users" group and restricting privileges
Next
From: "Jim C. Nasby"
Date:
Subject: Re: the "users" group and restricting privileges