On 2012-07-27, John R Pierce <pierce@xxxxxxxxxxxx> wrote: > On 07/27/12 12:30 PM, hartrc wrote: > and make each developer a member of this role. > >> Developers do not own the objects themselves > > thats a little more tricky, as AFAIK only a 'superuser' can change the > role that owns an object, by default its owned by the rule that created > it, but a user who's a member of a group can SET ROLE group; and then > any objects they create belong to that group, or they can ALTER > TABLE/VIEW/etc name OWNER TO newowner; for any role they are a member of. > after doing grant developer to USERNAME; you can do alter user USERNAME set role to developer; then when USERNAME logs it will be as if they had done "set role to developer;" -- ⚂⚃ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
