Re: altering objects owned by other user - Mailing list pgsql-general

From Marc Munro
Subject Re: altering objects owned by other user
Date
Msg-id 1139957425.5892.9.camel@bloodnok.com
Whole thread Raw
In response to Re: altering objects owned by other user  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom,
Thanks.  Good suggestions, both.  I'm going to defer this problem until
we are able to upgrade.

__
Marc

On Mon, 2006-02-13 at 14:18 -0500, Tom Lane wrote:
> 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

Attachment

pgsql-general by date:

Previous
From: andrew
Date:
Subject: stateful UDF?
Next
From: Michael Fuhr
Date:
Subject: Re: stateful UDF?