From: | Jason Dixon <jason(at)dixongroup(dot)net> |
---|---|
To: | Bruno Wolff III <bruno(at)wolff(dot)to> |
Cc: | PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Grant on multiple objects |
Date: | 2005-01-01 19:33:48 |
Message-ID: | 0F58FC76-5C2C-11D9-AF1C-000D93C63BA8@dixongroup.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Jan 1, 2005, at 2:18 PM, Bruno Wolff III wrote:
> On Sat, Jan 01, 2005 at 11:04:16 -0500,
> Jason Dixon <jason(at)dixongroup(dot)net> wrote:
>> 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:
>
> Yes, but not the way you want. You can list multiple objects of the
> same
> type when issuing a GRANT command. However you can't use a query in the
> GRANT statement to generate the list. If you are doing this
> programatically
> you could do a select for each type and use the results to build GRANT
> statements.
Thanks for clarifying this. I guess I'll write a DBD::Pg script to
automate much of the work.
--
Jason Dixon
DixonGroup Consulting
http://www.dixongroup.net
From | Date | Subject | |
---|---|---|---|
Next Message | K Anderson | 2005-01-02 03:38:16 | LOOping clobbering variable |
Previous Message | Bruno Wolff III | 2005-01-01 19:18:07 | Re: Grant on multiple objects |