createdb but revoke dropdb

From: Ben Eliott <ben(dot)apperrors(at)googlemail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: createdb but revoke dropdb
Date: 2010-03-02 18:22:17
Message-ID: 5CD318FC-0AFF-46ED-AA18-8ED1CCE21EE5@googlemail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
In using 8.3. I'm trying to set up programmatic database creation but
is there a way that the user creating the databases can be restricting
from dropping them?

I have two roles, 'adminuser' with createdb permission, and 'dbuser' a
user with CRUD privileges.

adminuser is a member of the dbuser role, this seems to allow
adminuser to createdb databases for dbuser with:
createdb -U adminuser -O dbuser new_database_name
Adding .pgpass to the linux user's home directory allows createdb to
work without additional user input.

But now it seems the linux user also has dropdb privileges. How can i
restrict this?
Perhaps there is a recommended method to disable dropdb? Can anyone
suggest?

The adminuser has no login privileges so by removing dropdb this
should remove the possibility for any hacker chaos other than creating
more databases?

Thanks in advance for any advice,
Ben

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lee Hachadoorian 2010-03-02 18:42:34 Re: Array columns vs normalized table
Previous Message Bruce Momjian 2010-03-02 18:14:00 Re: [GENERAL] trouble with to_char('L')