On Fri, Aug 2, 2013 at 1:36 PM, Bosco Rama <postgres@xxxxxxxxxxxxx> wrote:
On 08/02/13 10:56, Melvin Call wrote:Heh. You almost have the words already:
>
> If I may pigtail another related question, what is the procedure for
> allowing another user access to that schema?
grant usage on schema hrschema to hr_user;
Too easy! Thanks for the help. That'll teach me to try to learn something new in the middle of development crunch time! And many thanks for the link as well. This will help a great deal.
This will allow them to see the objects in the schema. It does nothing
to allow them to access the objects themselves, so you'll still need to
grant the appropriate privileges on the objects within the schema. You
can use default privileges if you don't wish to grant them at creation
time. See the docs for default privs:
<http://www.postgresql.org/docs/9.2/static/sql-alterdefaultprivileges.html>
HTH,
Bosco.
