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

From Larry Rosenman
Subject Re: Granting Privleges on All Tables in One Comand?
Date
Msg-id D1D2D51E3BE3FC4E98598248901F75940328D970@ausmail2k4.aus.pervasive.com
Whole thread Raw
In response to Granting Privleges on All Tables in One Comand?  ("Adam" <adam@spatialsystems.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Returning SQL statement
Next
From: "George Woodring"
Date:
Subject: Issue with fixseq.sql in 8.1 release notes