INSERT INTO blc_user_permission(id, "name", last_updated)
VALUES ('-2000', 'READ_MY_DOMAIN', '2021-01-01 12:00:00.000'),
('-2001', 'ALL_MY_DOMAIN', '2021-01-01 12:00:00.000');
-- -1 Partial access user
-- -2 Full access user
INSERT INTO blc_role_permission_xref (role_id, permission_id)
VALUES ('-1', '-2000'),
('-2', '-2001');
INSERT INTO blc_security_scope (id, "name", "open")
VALUES ('-2000', 'MY_DOMAIN', 'N');
INSERT INTO blc_permission_scope(id, permission, is_permission_root, scope_id)
VALUES ('-2000', 'MY_DOMAIN', 'Y', '-2000');
-- example here uses the OpenAPI client, but each client that needs to hit the endpoint needs a row
INSERT INTO blc_client_permissions(id, permission)
VALUES ('openapi', 'ALL_MY_DOMAIN');
INSERT INTO blc_client_scopes(id, scope)
VALUES ('openapi', 'MY_DOMAIN');