Drizzle-kit push - pgPolicy ignores using configuration
Policy:
pgPolicy("Users can view their own active organization memberships", {
for: "select",
to: authenticatedRole,
using: and(
eq(table.userId, sql
(select requesting_user_id())),
eq(table.status, sql'active'),
),
})
Statement created with push:
CREATE POLICY "Organization members can view their associated organizations test" ON "organizations" AS PERMISSIVE FOR SELECT TO "authenticated";
The migration created doesnt have this issue.1 Reply
Also experiencing this. On latest version, 0.36.1