Re: ACLs versus ALTER OWNER

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ACLs versus ALTER OWNER
Date: 2004-06-02 15:22:53
Message-ID: 40BDF0CD.60100@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> Someone else suggested having pg_dump dump all objects without ownership
> (so, on restore, they'd all initially be owned by the user running the
> script, hopefully a superuser) and then doing ALTER OWNERs and GRANTs at
> the bottom.

Actually, this would probably only be reasonable if you fixed the ACLs
after an ALTER OWNER, like you proposed earlier.

Chris

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-06-02 15:29:47 Re: Converting postgresql.conf parameters to kilobytes
Previous Message Christopher Kings-Lynne 2004-06-02 15:21:44 Re: ACLs versus ALTER OWNER