Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> Adam wrote:
>>> Is it possible to 'GRANT SELECT ON ALL TABLES TO User' in 1 command
>>> ?
>>>
>>> I saw the question in 2003 and wonder if it's still true.
>
>> Still true, but on the TODO list:
>
> Also, you can do it today by making a plpgsql function that iterates
> through all the tables and does GRANTs. There are examples in the
> mailing list archives. (The TODO item would probably have been done
> by now if it weren't so easy to work around it.)
>
One example:
http://www.archonet.com/pgdocs/grant-all.html
--
Larry Rosenman
Database Support Engineer
PERVASIVE SOFTWARE. INC.
12365B RIATA TRACE PKWY
3015
AUSTIN TX 78727-6531
Tel: 512.231.6173
Fax: 512.231.6597
Email: Larry.Rosenman@pervasive.com
Web: www.pervasive.com