Postgres Pro
Downloads
Home   >   mailing lists

Re: Granting Privleges on All Tables in One Comand? - Mailing list pgsql-general

From Tom Lane
Subject Re: Granting Privleges on All Tables in One Comand?
Date
Msg-id 1403.1137043149@sss.pgh.pa.us
Whole thread Raw
In response to Re: Granting Privleges on All Tables in One Comand?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
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.)

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: sql (Stored procedure) design question
Next
From: Michael Fuhr
Date:
Subject: Re: getting access to geodistance (what do I need to install/enable) in an existing db install