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

From Dan Tenenbaum
Subject Re: the "users" group and restricting privileges
Date
Msg-id 65029d820511291836m34e12bceucbba4c120a2a8d9f@mail.gmail.com
Whole thread Raw
In response to Re: the "users" group and restricting privileges  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Thanks to both you and Jim--this was the missing piece that made things work.


On 11/29/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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: "Jim C. Nasby"
Date:
Subject: Re: the "users" group and restricting privileges
Next
From: "Tomeh, Husam"
Date:
Subject: upgrade database to 8.1 - 2GB file limit (pg_dump)