Grant on multiple objects

From: Jason Dixon <jason(at)dixongroup(dot)net>
To: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Grant on multiple objects
Date: 2005-01-01 16:04:16
Message-ID: C9C91E71-5C0E-11D9-B58C-000D93C63BA8@dixongroup.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Is it possible to GRANT permissions on multiple objects at once? I
would like to assign limited permissions on multiple objects (tables,
indices, sequences in the same database) without granting full
ownership. For example, something like this:

GRANT SELECT, INSERT, UPDATE on (SELECT relname FROM pg_class WHERE
relkind in ('r', 'i', 'S') AND relnamespace=2200) to jason;

Is this possible? I understand from reading the documentation that
this is not in the SQL standard, but I'm hopeful there is some type of
work-around.

Thanks,

--
Jason Dixon
DixonGroup Consulting
http://www.dixongroup.net

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruno Wolff III 2005-01-01 19:18:07 Re: Grant on multiple objects
Previous Message Michael Fuhr 2004-12-31 05:38:08 Re: adding a new data to existing psql table from comma del file