data-catalog-api/server/simple-sharing/src/main/resources/schema.sql [22:34]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
SELECT
    dph.data_product_id AS data_product_id,
    su.user_id AS user_id,
    CASE
        WHEN s.permission_id = 'OWNER' THEN 0
        WHEN s.permission_id = 'READ' THEN 1
        WHEN s.permission_id = 'READ_METADATA' THEN 2
        WHEN s.permission_id = 'WRITE' THEN 3
        WHEN s.permission_id = 'WRITE_METADATA' THEN 4
        WHEN s.permission_id = 'MANAGE_SHARING' THEN 5
        ELSE NULL
    END AS permission_id
FROM
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



data-catalog-api/server/simple-sharing/src/main/resources/schema.sql [39:51]:
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
SELECT
    dph.data_product_id AS data_product_id,
    su.user_id AS user_id,
    CASE
        WHEN s.permission_id = 'OWNER' THEN 0
        WHEN s.permission_id = 'READ' THEN 1
        WHEN s.permission_id = 'READ_METADATA' THEN 2
        WHEN s.permission_id = 'WRITE' THEN 3
        WHEN s.permission_id = 'WRITE_METADATA' THEN 4
        WHEN s.permission_id = 'MANAGE_SHARING' THEN 5
        ELSE NULL
    END AS permission_id
FROM
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



