Thread: Dumping grants

Dumping grants

From
richard terry
Date:
?Any way to dump the grants on all tables/sequences in a DB to a text file?

regards

richard

Re: Dumping grants

From
Tom Lane
Date:
richard terry <rterry@pacific.net.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