Обсуждение: Extracting \ Generate DDL for existing object permissions
Hello all, How do I capture the EXISTING permissions for a database? I know you can see them via \z or \dp however I need ALL permissions to be captured so I can reapply after performing a database restore. ex: 1) dump database A - 2) Extract permissions from database B - (HOW????) 3) load database B from A - 4) execute sql to put permissions back to database B from step 2 Thanks...Michelle -- View this message in context: http://www.nabble.com/Extracting-%5C-Generate-DDL-for-existing-object-permissions-tp17413948p17413948.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
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 ------------------------------------------------------------------
Raymond O'Donnell wrote: > 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..."? Hint: sometimes easier is to run pg_dump -fc and then pg_restore -l to create an object list and operate your filters on this list, then use the resulting list with pg_restore -L With GRANTS, which are one-liners, it works either way. But the general approach works very well with any statement, think of multiline create table, create function ... Cheers Tino