mirror of
https://github.com/coder/coder.git
synced 2025-07-03 16:13:58 +00:00
f34e6fd92c
Template `use` is now a verb. - Template admins can `use` all templates (org template admins same in org) - Members get the `use` perm from the `everyone` group in the `group_acl`.
13 lines
585 B
SQL
13 lines
585 B
SQL
-- With the "use" verb now existing for templates, we need to update the acl's to
|
|
-- include "use" where the permissions set ["read"] is present.
|
|
-- The other permission set is ["*"] which is unaffected.
|
|
|
|
UPDATE
|
|
templates
|
|
SET
|
|
-- Instead of trying to write a complicated SQL query to update the JSONB
|
|
-- object, a string replace is much simpler and easier to understand.
|
|
-- Both pieces of text are JSON arrays, so this safe to do.
|
|
group_acl = replace(group_acl::text, '["read"]', '["read", "use"]')::jsonb,
|
|
user_acl = replace(user_acl::text, '["read"]', '["read", "use"]')::jsonb
|