mirror of
https://git.meshkee.com/Meshkee/backend.git
synced 2026-08-11 22:30:59 +04:30
Alireza HassaniandCursor
e59db25814
Super-admins can assign Admin; owners/admins manage Editor/Viewer via team/access, and the customers list supports all/customers/managers filtering. Co-authored-by: Cursor <cursoragent@cursor.com>
14 lines
400 B
SQL
14 lines
400 B
SQL
-- Business team admins can manage non-admin staff (invite / update / remove).
|
|
-- Owners keep full team.* ; editors/viewers stay without team management.
|
|
|
|
INSERT INTO role_permissions (role_id, permission_id)
|
|
SELECT r.id, p.id
|
|
FROM roles r
|
|
JOIN permissions p ON p.slug IN (
|
|
'business.team.invite',
|
|
'business.team.update',
|
|
'business.team.remove'
|
|
)
|
|
WHERE r.slug = 'admin'
|
|
ON CONFLICT DO NOTHING;
|