Re: [GENERAL] altering objects owned by other user

2006-02-14 Thread Marc Munro
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 <[EMAIL PROTECTED]> writes: > > I want to allow a non-superuser to alter objects owned by another user. > > Use 8.1, have t

Re: [GENERAL] altering objects owned by other user

2006-02-13 Thread Tom Lane
Marc Munro <[EMAIL PROTECTED]> 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

[GENERAL] altering objects owned by other user

2006-02-13 Thread Marc Munro
I want to allow a non-superuser to alter objects owned by another user. This should be an audited operation (logging a notice of what was done to the postgres logs is sufficient). This is so that I can allow trusted users to perform maintenance operations without having to give them either superus