What you will learn:
How the Data API uses Row-Level Security
Row-Level Security (RLS) is a Postgres feature that controls access to individual rows in a table based on the current user. Here's a simple example that limits the notes a user can see by matching rows where their user_id matches the session's auth.user_id().
The auth.user_id() function is available after you enable the Data API on a branch. The example also needs a notes table. Create one, and grant the authenticated role access to it. RLS filters the rows, but the role still needs table privileges first:
CREATE TABLE notes (
id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
user_id text NOT NULL,
body text
);
GRANT SELECT, INSERT, UPDATE, DELETE ON notes TO authenticated;Then enable RLS and add the policy:
-- Enable RLS on a table
ALTER TABLE notes ENABLE ROW LEVEL SECURITY;
-- Create a policy that only allows users to access their own notes
CREATE POLICY "users_can_only_access_own_notes" ON notes
FOR ALL USING (auth.user_id() = user_id);The policy has no WITH CHECK clause, so Postgres applies the same condition to new and changed rows. A user can't insert a row for another user, or change a row's user_id to another user's ID.
When using the Data API for client-side querying, RLS policies are required to secure your data.
Data API with RLS
The Data API turns your database tables on a given branch into a REST API. Enable RLS on every table you expose through it. Without RLS, authenticated users can read every row in a table.
How it works
- The Data API handles JWT validation and provides the
auth.user_id()function. - Your RLS policies use
auth.user_id()to control access. - Grant the
authenticatedrole the table privileges it needs. The Data API doesn't add its own permission layer, so grants and policies together decide what each request can access.
RLS with Drizzle ORM
Drizzle makes it simple to write RLS policies that work with the Data API. We highly recommend using its crudPolicy helper to simplify common RLS patterns.
Postgres RLS Tutorial
To learn the fundamentals of Row-Level Security in Postgres, including detailed concepts and examples, see the Postgres tutorial:








