Grant on multiple objects - Mailing list pgsql-novice

From Jason Dixon
Subject Grant on multiple objects
Date
Msg-id C9C91E71-5C0E-11D9-B58C-000D93C63BA8@dixongroup.net
Whole thread Raw
Responses Re: Grant on multiple objects
List 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


pgsql-novice by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: adding a new data to existing psql table from comma del file
Next
From: Bruno Wolff III
Date:
Subject: Re: Grant on multiple objects