Re: Granting Privleges on All Tables in One Comand?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Adam <adam(at)spatialsystems(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Granting Privleges on All Tables in One Comand?
Date: 2006-01-12 05:19:09
Message-ID: 1403.1137043149@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-01-12 05:47:55 Re: getting access to geodistance (what do I need to install/enable) in an existing db install
Previous Message Tom Lane 2006-01-12 05:16:05 Re: sql (Stored procedure) design question