coder/000287_template_read_to_use.down.sql at main - coder - Ahri Cloud Code

synced/coder

mirror of https://github.com/coder/coder.git synced 2025-07-03 16:13:58 +00:00

Files

Steven Masley f34e6fd92c chore: implement 'use' verb to template object, read has less scope now (#16075 )

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`.

2025-01-17 11:55:41 -06:00

6 lines

173 B

SQL

Raw Permalink Blame History

 UPDATE
 	templates
 SET
 	group_acl = replace(group_acl::text, '["read", "use"]', '["read"]')::jsonb,
 	user_acl = replace(user_acl::text, '["read", "use"]', '["read"]')::jsonb