aboutsummaryrefslogtreecommitdiff
path: root/migrations/auth/20230210_01_8xMa1-system-admin-privileges-for-data-distribution.py
blob: 8b406a6bfc35de0f105da88e9bf197ad5f4504fd (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
"""
System admin privileges for data distribution

These privileges are focussed on allowing the system administrator to link the
datasets and traits in the main database to specific groups in the auth system.
"""

from yoyo import step

__depends__ = {'20230207_01_r0bkZ-create-group-join-requests-table'}

steps = [
    step(
        """
        INSERT INTO privileges VALUES
          ('system:data:link-to-group', 'Link a dataset or trait to a group.')
        """,
        """
        DELETE FROM privileges WHERE privilege_id IN
         ('system:data:link-to-group')
        """)
]