Re: forcing table ownership

> -----Original Message-----
> From: Andy Colson [mailto:andy(at)squeakycode(dot)net]
> Sent: Thursday, September 15, 2011 7:51 PM
> To: Darin Perusich
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] forcing table ownership
>
> On 09/15/2011 04:31 PM, Darin Perusich wrote:
> > Hi Andy,
> >
> >>
> >> Any way you can update to PG 9?
> >>
> >> http://www.postgresql.org/docs/9.0/static/sql-
> >> alterdefaultprivileges.html
> >
> > That's not really an option I'd like to consider. I really don't
want
> to
> > deploy anything outside of what's distributed with the OS, since I
> have
> > a TON of opensuse servers to keep track of and there will be a bunch
> > running postgres.
> >
> > Thanks!
>
> How about "set role ..." then?
>
> http://www.postgresql.org/docs/8.4/static/sql-set-role.html
>

This works but it seems rather cumbersome to have to set the role every
time someone connects to the database. There has to be another way.

The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action
in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you are not the intended recipient of this
message, please contact the sender and delete this material from this computer.