Re: User authorization

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Wayne Johnson <wdtj(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: User authorization
Date: 2005-06-28 16:21:29
Message-ID: 20050628162129.GI24207@ns.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Wayne Johnson (wdtj(at)yahoo(dot)com) wrote:
> Is there a way to do this automatically? Say, to make all new objects
> accessible (or even owned) by a group? Something like the sticky bit in
> a directory on UNIX.

8.1 is expected to have Roles support in it, which merges users and
groups into one space. Roles can log in, can have passwords, and can
have members. Members of a role have the permissions (including
owner-level permissions for objects owned by that role) of the role.

Personally I'd really like to see a way to set the 'default owner' for a
schema to help with exactly these issues. That wasn't included in the
Roles support but I think is a natural follow-on to it since the schema
could be owned by a Role which has members.

Thanks,

Stephen

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Zlatko Matic 2005-06-28 17:07:20 Re: automating backup ?
Previous Message Ben Hallert 2005-06-28 15:43:29 Re: Generate a list of (days/hours) between two dates