> -----Original Message----- > From: Andy Colson [mailto:andy@xxxxxxxxxxxxxxx] > Sent: Thursday, September 15, 2011 7:51 PM > To: Darin Perusich > Cc: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
