Re: forcing table ownership - Mailing list pgsql-general

From Andy Colson
Subject Re: forcing table ownership
Date
Msg-id 4E726C12.1030909@squeakycode.net
Whole thread Raw
In response to forcing table ownership  ("Darin Perusich" <Darin.Perusich@ctg.com>)
Responses Re: forcing table ownership  ("Darin Perusich" <Darin.Perusich@ctg.com>)
List pgsql-general
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 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 I
> accomplish this?
>
> What I want to do is create a database group with ALL privs on a
> database, assign X number of users to it, and allow them to have their
> way with the database. I've done this but the behavior is the same as
> mentioned above, nobody other than the table owner can access the
> tables.
>
> Postgres 8.4.7 on OpenSUSE 11.3
> - Users are authenticating against LDAP
> - User are being created with "createuser -S -D -R user#"
> - Group creation "CREATE GROUP grp1;"
> - Added users to group with "ALTER GROUP grp1 ADD USER user1, user2:"
> - Grant DB priv's "GRANT ALL ON database1 TO GROUP grp1;"
>
> Thanks!
> --
> Darin Perusich
> Email: Darin.Perusich@ctg.com
> Office: 716-888-3690

Any way you can update to PG 9?

http://www.postgresql.org/docs/9.0/static/sql-alterdefaultprivileges.html

-Andy


pgsql-general by date:

Previous
From: "Darin Perusich"
Date:
Subject: forcing table ownership
Next
From: Jeff Adams
Date:
Subject: Re: Remote connection shows localhost databases