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

From Joshua D. Drake
Subject Re: Granting Privleges on All Tables in One Comand?
Date
Msg-id 43C5F396.9080909@commandprompt.com
Whole thread Raw
In response to Granting Privleges on All Tables in One Comand?  ("Adam" <adam@spatialsystems.org>)
List pgsql-general
Adam wrote:

> Is it possible to 'GRANT SELECT ON ALL TABLES TO User' in 1 command ?


No it is not. But you easily loop it with a one line script :)

>
> I saw the question in 2003 and wonder if it's still true.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org



--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/


pgsql-general by date:

Previous
From: Assad Jarrahian
Date:
Subject: Re: sql (Stored procedure) design question
Next
From: "Jonel Rienton"
Date:
Subject: Re: Finding orphan records