Re: Per-Database Roles

From: Stephen Frost <frost(dot)stephen(dot)p(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Thom Brown <thom(at)linux(dot)com>, Florian Pflug <fgp(at)phlo(dot)org>, Stephen Frost <sfrost(at)snowman(dot)net>, Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Per-Database Roles
Date: 2012-05-22 17:28:07
Message-ID: -1705304821428018513@unknownmsgid
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On May 22, 2012, at 12:18, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Another objection is that it wouldn't scale up nicely to multiple levels
> of catalog hierarchy. But maybe local/global is enough.

That would be a huge improvement and this wouldn't get in the way of
any solution to the global oid conflict issue coming along in the
future..

We still have the issue of name conflict between the global roles and
the local roles, right? Unless we allow those to overlap and pick
whatever is "closest"? Then there is the question of role membership
and if we would allow that to go between local and global or what the
semantics of that would look like..

Thanks,

Stephen

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2012-05-22 17:28:36 Re: Readme of Buffer Management seems to have wrong sentence
Previous Message Simon Riggs 2012-05-22 17:27:49 Re: Changing the concept of a DATABASE