-- new client for Bulk Ops Service
INSERT INTO BLC_CLIENT (ID, attributes, client_id, friendly_name, is_admin, auth_server_id,
token_timeout_seconds, refresh_token_rot_intrvl_scnds,
refresh_token_timeout_seconds, client_authentication_methods)
VALUES ('bulkopsclient', '{}', 'bulkopsclient', 'Bulk Operations Client', 'N', 2, 300, 60, 7200,
'["client_secret_basic"]');
insert into BLC_CLIENT_GRANT_TYPES
VALUES ('bulkopsclient', 'client_credentials');
INSERT INTO BLC_CLIENT_SCOPES (ID, "SCOPE")
VALUES ('bulkopsclient', 'BULK_OPERATION');
INSERT INTO BLC_CLIENT_PERMISSIONS (ID, "PERMISSION")
VALUES ('bulkopsclient', 'ALL_BULK_OPERATION');
INSERT INTO BLC_SECURITY_SCOPE (ID, NAME, OPEN)
VALUES ('-811', 'BULK_OPERATION', 'N');
INSERT INTO BLC_PERMISSION_SCOPE (ID, PERMISSION, IS_PERMISSION_ROOT, SCOPE_ID)
VALUES ('-812', 'BULK_OPERATION', 'Y', '-811');
INSERT INTO BLC_USER_PERMISSION (ID, archived, last_updated, NAME, is_account_perm, user_assignable)
VALUES ('-811', 'N', '1970-01-01 00:00:00.000000', 'ALL_BULK_OPERATION', 'N', 'Y');
INSERT INTO BLC_USER_PERMISSION (ID, archived, last_updated, NAME, is_account_perm, user_assignable)
VALUES ('-812', 'N', '1970-01-01 00:00:00.000000', 'READ_BULK_OPERATION', 'N', 'Y');
INSERT INTO BLC_ROLE_PERMISSION_XREF (ROLE_ID, PERMISSION_ID)
VALUES ('-2', '-811');
INSERT INTO BLC_ROLE_PERMISSION_XREF (ROLE_ID, PERMISSION_ID)
VALUES ('-1', '-812');
INSERT INTO BLC_CLIENT_SCOPES (ID, SCOPE)
VALUES ('openapi', 'BULK_OPERATION');
INSERT INTO BLC_CLIENT_PERMISSIONS (ID, PERMISSION)
VALUES ('openapi', 'ALL_BULK_OPERATION');
-- Needed for catalog search
INSERT INTO BLC_CLIENT_SCOPES (ID, "SCOPE")
VALUES ('bulkopsclient', 'PRODUCT');
INSERT INTO BLC_CLIENT_PERMISSIONS (ID, "PERMISSION")
VALUES ('bulkopsclient', 'ALL_PRODUCT');
-- Needed to allow search client provider calls with sandbox IDs via admin
INSERT INTO BLC_SECURITY_SCOPE (ID, NAME, OPEN)
VALUES ('-810', 'ADMIN_SCOPED_SERVICE_CLIENT', 'N');
INSERT INTO BLC_PERMISSION_SCOPE (ID, PERMISSION, IS_PERMISSION_ROOT, SCOPE_ID)
VALUES ('-811', 'ADMIN_SCOPED_SERVICE_CLIENT', 'Y', '-810');
INSERT INTO BLC_CLIENT_SCOPES (ID, "SCOPE")
VALUES ('bulkopsclient', 'ADMIN_SCOPED_SERVICE_CLIENT');
INSERT INTO BLC_CLIENT_PERMISSIONS (ID, "PERMISSION")
VALUES ('bulkopsclient', 'ALL_ADMIN_SCOPED_SERVICE_CLIENT');
