github-starred/better-auth
2
0
Fork 0
mirror of https://github.com/better-auth/better-auth.git synced 2026-05-23 07:18:56 -05:00
Code Issues 2.5k Packages Projects Releases 112 Wiki Activity

[PR #5987] feat(drizzle): Add Row Level Security (RLS) support for PSQL when using drizzle #14611

New Issue
Closed
opened 2026-04-13 09:32:30 -05:00 by GiteaMirror · 0 comments
GiteaMirror commented 2026-04-13 09:32:30 -05:00
Owner
Copy Link

Original Pull Request: https://github.com/better-auth/better-auth/pull/5987

State: closed
Merged: No

Add PostgreSQL Row Level Security (RLS) to Drizzle Schema Generator

Summary

Adds optional Row Level Security (RLS) support when generating Drizzle schemas for PostgreSQL. When enabled, generated tables automatically include .enableRLS().

Changes

Core

  • Added enableRLS option to DrizzleAdapterConfig (PostgreSQL only).
  • Schema generator now checks adapter.options?.enableRLS and appends .enableRLS() to each table definition.
  • RLS is only applied when the provider is PostgreSQL and the flag is enabled ( all other providers will simply ignore this flag )

Testing

  • Added tests for PostgreSQL with RLS enabled.
  • Added tests for PostgreSQL + passkey plugin with RLS.
  • Added snapshots for RLS-enabled schema generation.

Usage

const adapter = drizzleAdapter(db, {
  provider: "pg",
  schema: {},
  enableRLS: true, // Enable RLS
});

Technical Details

  • RLS applies only when:

    • databaseType === "pg"
    • adapter.options?.enableRLS === true

  • .enableRLS() is appended to every pgTable() call.

Summary by cubic

Adds optional PostgreSQL Row Level Security to Drizzle schema generation. When enableRLS is true in the adapter config, generated pgTable() definitions include .enableRLS().

  • New Features
    • Added enableRLS?: boolean to DrizzleAdapterConfig (PostgreSQL only).
    • Generator appends .enableRLS() to tables when provider === "pg" and enableRLS is true.
    • Other providers ignore this flag.
    • Added tests and snapshots for RLS (including passkey plugin).

Written for commit 5600ca1725. Summary will update automatically on new commits.

**Original Pull Request:** https://github.com/better-auth/better-auth/pull/5987 **State:** closed **Merged:** No --- ## Add PostgreSQL Row Level Security (RLS) to Drizzle Schema Generator ### Summary Adds optional Row Level Security (RLS) support when generating Drizzle schemas for PostgreSQL. When enabled, generated tables automatically include `.enableRLS()`. --- ### Changes #### Core * Added `enableRLS` option to `DrizzleAdapterConfig` (PostgreSQL only). * Schema generator now checks `adapter.options?.enableRLS` and appends `.enableRLS()` to each table definition. * RLS is only applied when the provider is PostgreSQL and the flag is enabled ( all other providers will simply ignore this flag ) #### Testing * Added tests for PostgreSQL with RLS enabled. * Added tests for PostgreSQL + passkey plugin with RLS. * Added snapshots for RLS-enabled schema generation. --- ### Usage ```ts const adapter = drizzleAdapter(db, { provider: "pg", schema: {}, enableRLS: true, // Enable RLS }); ``` --- ### Technical Details * RLS applies only when: * `databaseType === "pg"` * `adapter.options?.enableRLS === true` * `.enableRLS()` is appended to every `pgTable()` call. --- <!-- This is an auto-generated description by cubic. --> --- ## Summary by cubic Adds optional PostgreSQL Row Level Security to Drizzle schema generation. When enableRLS is true in the adapter config, generated pgTable() definitions include .enableRLS(). - New Features - Added enableRLS?: boolean to DrizzleAdapterConfig (PostgreSQL only). - Generator appends .enableRLS() to tables when provider === "pg" and enableRLS is true. - Other providers ignore this flag. - Added tests and snapshots for RLS (including passkey plugin). <sup>Written for commit 5600ca1725833c66f3b281d085151103aabe90f3. Summary will update automatically on new commits.</sup> <!-- End of auto-generated description by cubic. -->
GiteaMirror added the pull-request label 2026-04-13 09:32:30 -05:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
adapter
astro
awaiting external contributor
blocked
breaking
breaking change
bug
c-devops
core
credentials
database
dependencies
devops
devtools
docs
documentation
duplicate
elysia
enhancement
enterprise
expo
express
fastify
good first issue
help wanted
hono
identity
infra
integration
invalid
javascript
locked
maintenance
need-more-information
needs: info
needs: repro
nextjs
nuxt
oauth
organization
P0
payments
perf
platform
plugin
pull-request
Mirrored from GitHub Pull Request
 question
ready
regression
remix
security
social-provider
solid
stale
svelte
tanstack-start
tracking
version-bump
vue
wontfix
No Label pull-request
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/better-auth#14611
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?