20 lines
744 B
PL/PgSQL
20 lines
744 B
PL/PgSQL
-- Rollback for AwoooP RLS Canary Wave 1.2.
|
|
-- This removes project table policies and disables RLS on awooop_projects.
|
|
-- It intentionally keeps awooop_operator_list_projects() so deployed API code
|
|
-- that uses the operator list path remains compatible.
|
|
|
|
BEGIN;
|
|
|
|
SET LOCAL lock_timeout = '5s';
|
|
SET LOCAL statement_timeout = '30s';
|
|
|
|
DROP POLICY IF EXISTS awooop_projects_select_tenant ON awooop_projects;
|
|
DROP POLICY IF EXISTS awooop_projects_insert_tenant ON awooop_projects;
|
|
DROP POLICY IF EXISTS awooop_projects_update_tenant ON awooop_projects;
|
|
DROP POLICY IF EXISTS awooop_projects_delete_tenant ON awooop_projects;
|
|
|
|
ALTER TABLE awooop_projects NO FORCE ROW LEVEL SECURITY;
|
|
ALTER TABLE awooop_projects DISABLE ROW LEVEL SECURITY;
|
|
|
|
COMMIT;
|