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
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 |