How can I give current user createDB permissions

General
1

I am trying to connect neon to my test database (using rails). I manage the connection but as part of running tests I create databases. Default user doesn’t have permission to create database. How can I create root user in my project or make my user root user.

2 Likes
2

Hi! We (yet) don’t give permission to create a database from SQL, but you can navigate to settings > databases to create a new one.

3

@Stas_Kelvich is the ability to create databases from SQL on the roadmap? Thanks.

4

Hello, just wanted to check if you had an update on this and if creating databases from SQL was on the roadmap. Best,

5

Also tagging in to request this.

My integration testing makes extensive use of fresh databases and the test harness calls CREATE DATABASE {prefix}_{random string} before every set of isolated tests