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

From Thomas G. Lockhart
Subject Re: [HACKERS] Postgres acl
Date
Msg-id b38e7d569e5a71446345765f52fbef7d
Whole thread Raw
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: Peter T Mount
Date:
Subject: Re: [HACKERS] I want to change libpq and libpgtcl for better handling of large query results
Next
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] My 2c on adjustable blocksizes