Hi Richard,
> -Original Message-
> From: Richard Huxton [mailto:d...@archonet.com]
> Sent: Friday, September 16, 2011 9:54 AM
> To: Darin Perusich
> Cc: Richard Broersma; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] forcing table ownership
>
> On 16/09/
On 16/09/11 14:13, Darin Perusich wrote:
Altering the table owner by setting it to the group role effectively
denies permission to all users of the group. Unless they explicitly "SET
role grp1" that is.
I've already got a user "richardh"
As a superuser:
CREATE GROUP mygroup INHERIT;
GRANT
Hi Richard,
> > I'm trying to accomplish is to have multiple users/roles connect to
a
> > database and have ALL privileges to do whatever they want. The
> problem
> > I'm running into is that is user1 creates table1 nobody else has
> > permissions to it since they are not the table owner. How can
> -Original Message-
> From: Andy Colson [mailto:a...@squeakycode.net]
> Sent: Thursday, September 15, 2011 7:51 PM
> To: Darin Perusich
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] forcing table ownership
>
> On 09/15/2011 04:31 PM, Darin Per
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 O
On Thu, Sep 15, 2011 at 1:59 PM, Darin Perusich wrote:
> I'm pretty much brand new to using postgres and the privilege structure
> is taking some getting used to, especially when coming from mysql. What
> I'm trying to accomplish is to have multiple users/roles connect to a
> database and have AL
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 server
On 9/15/2011 3:59 PM, Darin Perusich wrote:
Hello,
I'm pretty much brand new to using postgres and the privilege structure
is taking some getting used to, especially when coming from mysql. What
I'm trying to accomplish is to have multiple users/roles connect to a
database and have ALL privilege
Hello,
I'm pretty much brand new to using postgres and the privilege structure
is taking some getting used to, especially when coming from mysql. What
I'm trying to accomplish is to have multiple users/roles connect to a
database and have ALL privileges to do whatever they want. The problem
I'm ru
