Skip to content

The easy-to-use open source Business Intelligence and Embedded Analytics tool that lets everyone work with data :bar_chart:

291 B
Raw Blame
DELETE FROM permissions WHERE object LIKE '/details/db/%';

INSERT INTO permissions (object, group_id)
SELECT concat('/details/db/', dp.db_id, '/'),
       dp.group_id
FROM data_permissions dp
WHERE dp.perm_type = 'perms/manage-database'
  AND dp.perm_value = 'yes'
AND dp.table_id IS NULL;