Re: Granting Privleges on All Tables in One Comand?

Tom Lane wrote:
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(dot)Rosenman(at)pervasive(dot)com
Web: www.pervasive.com