Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: altering objects owned by other user
Date
Msg-id 3672.1139858287@sss.pgh.pa.us
Whole thread Raw
In response to altering objects owned by other user  (Marc Munro <marc@bloodnok.com>)
Responses Re: altering objects owned by other user  (Marc Munro <marc@bloodnok.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Marc Munro
Date:
Subject: altering objects owned by other user
Next
From: Stephan Szabo
Date:
Subject: Re: Why does an ON SELECT rule have to be named "_RETURN"?