Files
windmill/backend/migrations/20240113112935_remove_account_perms.up.sql
2024-01-13 13:00:04 +01:00

12 lines
361 B
SQL

-- Add up migration script here
DROP POLICY IF EXISTS see_own ON account;
DROP POLICY IF EXISTS see_member ON account;
DROP POLICY IF EXISTS see_folder_extra_perms_user on account;
ALTER TABLE account DISABLE ROW LEVEL SECURITY;
ALTER TABLE account DROP COLUMN IF EXISTS owner;
GRANT ALL ON account TO windmill_admin;
GRANT ALL ON account TO windmill_user;