Files
coder/coderd/database/migrations/000086_no_org_admins.up.sql
Steven Masley 27386d49d0 fix: No org admins until organizations are in the UI (#5414)
* fix: No org admins until organizations are in the UI

Until organizations have management UI, we should not set any org
admins. This goes around the site wide perms transparently and
is confusing to users.

Default user is no longer an org admin, so the demotion test makes
no sense
2022-12-14 11:05:42 -06:00

7 lines
127 B
SQL

UPDATE
organization_members
SET
roles = ARRAY [] :: text[]
WHERE
'organization-admin:'||organization_id = ANY(roles);