Postgres acl
Kevin Witten <kwitten@qdt.com>
From: Kevin Witten <kwitten@qdt.com>
To: pghack <pgsql-hackers@postgreSQL.org>
Date: 1998-01-06T04:05:30Z
Lists: 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.