Re: [HACKERS] Postgres acl - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] Postgres acl
Date
Msg-id 34B1B4B6.3948CC8@alumni.caltech.edu
Whole thread Raw
In response to Postgres acl  (Kevin Witten <kwitten@qdt.com>)
List pgsql-hackers
> I believe I found a bug. If a user other than the postgres superuser is
> given permission to create databases, then he should be able to destroy
> the databases he creates. Currently he can't, at least in version 6.2.1
> complied for SunOS 5.5. Only the poostgres superuser can delete
> databases. If otherusers try they get the following error message:
>
> "WARN:pg_database: Permission denied.
> destroydb: database destroy failed on tmpdb."
>
> eventhough this user is the database admin for tmpdb as shown in the
> pd_database table.

At the moment, one requires "create users" privilege to destroy your own
database, but only "create databases" privilege to create one. I think
there is something about this on the ToDo list...

                                  - Tom


pgsql-hackers by date:

Previous
From: Integration
Date:
Subject: My 2c on adjustable blocksizes
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] subselect