| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: CREATE DATABASE foo OWNER bar |
| Date: | 2007-04-16 14:12:35 |
| Message-ID: | 20070416141235.GD5658@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Larry Rosenman wrote:
> Greetings,
> I think I found a bug, or at least a POLA violation. At work, I created
> a user that is NOT a superuser, nor can that user create databases. When I
> did a create database foo owner bar, all the schemas are set to be owned by
> the superuser that created the database, not the database owner.
>
> Shouldn't everything that is in the DB be owned by the purported owner?
Right. This is on TODO:
%Set proper permissions on non-system schemas during db creation
Currently all schemas are owned by the super-user because they are copied from
the template1 database.
I note it is marked with a %, but it's clearly not easy at all.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2007-04-16 14:38:09 | Re: CREATE DATABASE foo OWNER bar |
| Previous Message | Larry Rosenman | 2007-04-16 14:10:04 | Re: CREATE DATABASE foo OWNER bar |