NeonDbError: db error: ERROR: permission denied for schema drizzle

// src/db/migrate.ts
import { neon } from '@neondatabase/serverless';
import { drizzle } from 'drizzle-orm/neon-http';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import { resolve } from 'node:path';

export async function migrateLatest() {
  console.log('Running migrations...');
  const dbUrl: string = process.env.DATABASE_URL!;
  const client = neon(dbUrl);
  // const client = postgres(dbUrl, { max: 1 });

  const db = drizzle(client);
  // XXX(Phong): if you change `process.cwd()`, you need to change Dockerfile
  const dbDir = resolve(
    process.env.NODE_ENV === 'production' ? process.cwd() : __dirname,
    'migrations',
  );
  await migrate(db, {
    migrationsFolder: dbDir,
  });
  console.log('Migrations completed successfully');
  // client.end();
}

// src/db/migrate.ts
import { neon } from '@neondatabase/serverless';
import { drizzle } from 'drizzle-orm/neon-http';
import { migrate } from 'drizzle-orm/postgres-js/migrator';
import { resolve } from 'node:path';

export async function migrateLatest() {
  console.log('Running migrations...');
  const dbUrl: string = process.env.DATABASE_URL!;
  const client = neon(dbUrl);
  // const client = postgres(dbUrl, { max: 1 });

  const db = drizzle(client);
  // XXX(Phong): if you change `process.cwd()`, you need to change Dockerfile
  const dbDir = resolve(
    process.env.NODE_ENV === 'production' ? process.cwd() : __dirname,
    'migrations',
  );
  await migrate(db, {
    migrationsFolder: dbDir,
  });
  console.log('Migrations completed successfully');
  // client.end();
}

tsx src/db/migrate.ts --config=drizzle.config.ts

tsx src/db/migrate.ts --config=drizzle.config.ts

> p-stack-fs@0.1.0 migrate /Users/pthieu/www/p-stack-fs
> tsx src/db/migrate.ts --config=drizzle.config.ts

Running migrations...
(Use `node --trace-warnings ...` to show where the warning was created)
/Users/pthieu/www/p-stack-fs/node_modules/.pnpm/@neondatabase+serverless@0.5.0/node_modules/@neondatabase/serverless/index.js:1518
if(C===400){let{message:Q,code:j}=await S.json(),V=new Ve(Q);throw V.code=j,V}else{
                                                   ^


NeonDbError: db error: ERROR: permission denied for schema drizzle

Caused by:
    ERROR: permission denied for schema drizzle
...
Node.js v18.9.0

> p-stack-fs@0.1.0 migrate /Users/pthieu/www/p-stack-fs
> tsx src/db/migrate.ts --config=drizzle.config.ts

Running migrations...
(Use `node --trace-warnings ...` to show where the warning was created)
/Users/pthieu/www/p-stack-fs/node_modules/.pnpm/@neondatabase+serverless@0.5.0/node_modules/@neondatabase/serverless/index.js:1518
if(C===400){let{message:Q,code:j}=await S.json(),V=new Ve(Q);throw V.code=j,V}else{
                                                   ^


NeonDbError: db error: ERROR: permission denied for schema drizzle

Caused by:
    ERROR: permission denied for schema drizzle
...
Node.js v18.9.0