Chaaaaaaase
Chaaaaaaase
PostsComments
DTDrizzle Team
Created by Chaaaaaaase on 5/28/2024 in #help
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 only. When trying to run drizzle-kit migrate, I get a [...] 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. I manually created the migrations table with the matching columns and still get the error. Also, I can run the queries just fine manually, just not via migrate. No issues using push. Any help would be appreciated. Thanks!
5 replies