4 replies

Permission denied during 'migrate' command under locked-down database

I am working on a database that has certain restrictions in place for who owns what. My account in particular has full permissions on

public

public

only. When trying to run

drizzle-kit migrate

drizzle-kit migrate

, I get a

[...] permission denied for database [...]

[...] permission denied for database [...]

error. Unfortunately, this is all I can provide unless there's a way to get logs that might help.

I have my config defined as

// ...
verbose: true,
migrations: {
    table: 'migrations',
    schema: 'public',
},
// ...

// ...
verbose: true,
migrations: {
    table: 'migrations',
    schema: 'public',
},
// ...

so I would expect I'd only need permissions for

public

public

. I manually created the

migrations

migrations

table with the matching columns and still get the error.

Also, I can run the queries just fine manually, just not via

migrate

migrate

. No issues using

push

push

.

Any help would be appreciated. Thanks!