blob: 6335152b1cd7f69d023d8fb611ad6078f2a4c117 (
about) (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
"""
Add role management privileges to group-leader role
"""
from yoyo import step
__depends__ = {'20250609_01_LB60X-add-batch-edit-privileges', '20250609_02_9UBPl-assign-group-data-link-to-group-privilege-to-group-leader'}
steps = [
step(
"""
INSERT INTO role_privileges(role_id, privilege_id)
VALUES
('a0e67630-d502-4b9f-b23f-6805d0f30e30', 'resource:role:create-role'),
('a0e67630-d502-4b9f-b23f-6805d0f30e30', 'resource:role:delete-role'),
('a0e67630-d502-4b9f-b23f-6805d0f30e30', 'resource:role:edit-role')
""",
"""
DELETE FROM role_privileges
WHERE role_id='a0e67630-d502-4b9f-b23f-6805d0f30e30'
AND privilege_id IN (
'resource:role:create-role',
'resource:role:delete-role',
'resource:role:edit-role'
)
""")
]
|