On 3/7/18 10:05, Stephen Frost wrote:
> I liken this to a well-known and well-trodden feature for auto creating
> user home directories on Unix.
I don't think likening schemas to home directories is really addressing
the most typical use cases. Database contents are for the most part
carefully constructed in a collaborative way. If your organization has
three DBAs foo, bar, and baz, it's quite unlikely that they will want to
create or look at objects in schemas named foo, bar, or baz. More
likely, they will be interested in the schemas myapp or myotherapp. Or
they don't care about schemas and will want the database to behave as if
there wasn't a schema layer between the database and the tables.
The existing structures are not bad. They work for a lot of users. The
problem is just that by default everyone can do whatever they want in a
shared space. The fix is probably to not let them do that. What is
being discussed here instead is to let them do whatever they want in
their own non-shared spaces. That addresses the security concern, but
it doesn't support the way people actually work right now.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services