PostgreSQL user permissions for production

[Tricia Jenkins]

Hi,

I've been looking for advice on what database privileges should be granted in production to a user used for a Rails web app. Would you happen to know if CREATEDB is necessary? Would INSERT/SELECT/UPDATE/DELETE/TEMPORARY suffice?

I've sought advice from rubyonrails.org and the Ruby on Rails books available at O'Reilly and ended up here. Let me know if there is a better place to ask.

Thanks,

Tricia