Marc Munro <marc@bloodnok.com> writes:
> I want to allow a non-superuser to alter objects owned by another user.
Use 8.1, have the objects in question be owned by a group (role), grant
membership in the group as appropriate.
> This should be an audited operation (logging a notice of what was done
> to the postgres logs is sufficient).
Perhaps log_statement = ddl?
regards, tom lane