On 08/02/13 10:56, Melvin Call wrote: > > If I may pigtail another related question, what is the procedure for > allowing another user access to that schema? Heh. You almost have the words already: grant usage on schema hrschema to hr_user; 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
