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 [...]

[...] 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',
},
// ...

// ...
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!

dale•5/29/24, 6:12 PM

Run the command as a superuser

m83•7/25/24, 7:06 AM

I ran into the same issue with one of the cloud providers. Config is the same as yours, using

public

public

schema for migrations as I've only got access to it. The problem is that drizzledrizzle tries to run CREATE SCHEMA IF NOT EXISTS publicCREATE SCHEMA IF NOT EXISTS public which triggers permission denied (it can't create schemas, and in this case it shouldn't try as

public

public

is default one). Not sure yet what the solution is, but I think I'll drop drizzledrizzle for migrations (orm is still awesome!) - it generates too loose code to my liking, like migrations shouldn't have "if not exists" clauses..

Mm83 I ran into the same issue with one of the cloud providers. Config is the same as...

rphlmr ⚡•7/25/24, 7:56 AM

for if not exists their is a new rfc https://github.com/drizzle-team/drizzle-orm/discussions/2624
Do not hesitate to comment if you think about something that is not mentioned

GitHub

Updated Migration Process · drizzle-team drizzle-orm · Discussion #...

Migration process urgrade After a year of gathering feedback, we have collected enough information and identified cases that were not handled properly or need improvement. In the 0.33.0 drizzle ORM...

Rrphlmr ⚡👋 for if not exists their is a new rfc https://github.com/drizzle-team/drizzle-...

m83•10/10/24, 12:52 PM

@Raphaël M (@rphlmr)

any timeline when this RFC is planned to see daylight? This is the only blocker for me to have drizzle running e2e from standard dx of creating/updating schemas locally to running migrations in the cloud k8s environments. I'd patch the migrator in my node_modulesnode_modules, but this is very flaky solution that I'd like to drop

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

Similar Threads

Similar Threads

Similar Threads