Re: Dumping grants

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: richard terry <rterry(at)pacific(dot)net(dot)au>
Cc: "PostgreSQL - newbie" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Dumping grants
Date: 2010-10-18 01:57:41
Message-ID: 28363.1287367061@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

richard terry <rterry(at)pacific(dot)net(dot)au> writes:
> ?Any way to dump the grants on all tables/sequences in a DB to a text file?

There's no canned solution for that, but you could run "pg_dump -s"
and then grep the output for GRANT statements.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Lukasz Brodziak 2010-10-18 05:12:03 Re: Overriding local encoding defaults
Previous Message richard terry 2010-10-18 01:03:18 Dumping grants