Postgres Pro
Downloads
Home   >   mailing lists

Re: Extracting \ Generate DDL for existing object permissions - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: Extracting \ Generate DDL for existing object permissions
Date
Msg-id 4835EEA8.708@iol.ie
Whole thread Raw
In response to Extracting \ Generate DDL for existing object permissions  (smiley2211 <msramsey22@gmail.com>)
Responses Re: Extracting \ Generate DDL for existing object permissions
List pgsql-general
Tree view 
On 22/05/2008 22:33, smiley2211 wrote:

> 1) dump database A -
> 2) Extract permissions from database B - (HOW????)

How about dumping B using the plain-text format, then running the output
through grep, looking for lines starting with "GRANT..."?

Ray.


------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

pgsql-general by date:

Previous
From: smiley2211
Date:
Subject: Extracting \ Generate DDL for existing object permissions
Next
From: "Hiroaki Nakamura"
Date:
Subject: Is this correct usage of generate_series?