Used words
admin_permission_set_policy
AS
(
INSERT
INTO
policy(organization_id
principal_id
name
editable
visible)
SELECT
d.organization_id
d.owner_id
d.permission_set_name
true
true
FROM
data
d
ON
CONFLICT
DO
NOTHING
RETURNING
*
)
admin_permission_set_rule
rule(policy_id
admin)
p.id
p
admin_permission_set_rules__permission_sets
rules__permission_sets(rule_id
permission_set_id)
r.id
ps.id
r
JOIN
(p.id
=
r.policy_id)
(d.organization_id
p.organization_id
AND
p.name
d.permission_set_name)
permission_set
ps
(ps.name
)
admin_permission_set_rules__permission_sets
Create your own