Re: altering objects owned by other user

From: Marc Munro <marc(at)bloodnok(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: altering objects owned by other user
Date: 2006-02-14 22:50:25
Message-ID: 1139957425.5892.9.camel@bloodnok.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)bloodnok(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-02-14 23:13:29 Re: stateful UDF?
Previous Message andrew 2006-02-14 22:47:49 stateful UDF?