Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ' ' || au.id || ' ', au.email FROM accounts.users as au
- JOIN user_roles ur on au.id = ur.user_id JOIN roles r on ur.role_id = r.id WHERE r.name LIKE 'operator';
- SELECT * FROM "dictionary-security".security.users as au
- JOIN "dictionary-security".security.users_roles ur on au.id = ur.user_id JOIN "dictionary-security".security.roles r on ur.role_id = r.id WHERE r.name LIKE 'operator' AND
- au.account_id NOT IN ('51753556-0fe0-48f6-9556-56574ba04773',
- 'cdeeea40-6c55-4969-8001-61c4ce13287b',
- 'b3fb8f33-510c-42c6-ae2d-bd55991862db',
- 'c0012e18-78c2-4e31-8849-615183f667dd',
- '1631f631-3fa5-4da6-8546-02d386de7e48',
- '4f5bfebf-0f76-2a40-c2ad-048ccdec6a0b',
- 'bd7a6ac2-975b-7fb8-04ac-300c08d8024d',
- '2331d04a-108e-b18d-7a9f-9ed015197803',
- '38a2c67e-a835-876a-7bb4-2b34f1eb4df7',
- '909dae7d-171b-cdd6-6b45-b6165fafef80',
- '9108c753-73d1-2401-b644-670af7fae048',
- '4fa32ab0-f3b3-6b1f-49f5-130908348f20',
- '36085ad1-1eec-3853-7156-4a9b5cb46c1a',
- 'e9a11f54-172e-9091-93a1-6a13354bca39',
- '85cbb739-b34d-5202-3af9-75b64f56c837',
- '5e9b88ef-d85f-f009-1e55-b5aeb2c69d3b',
- '07a6a346-6895-71ed-1ed9-ca9fa0b40b8a',
- '52d66f15-febb-3be3-13cd-d092e89df8bb',
- 'c25d8154-d941-9cc3-5545-bc073e122eb1',
- '88b71f1e-1e19-79ff-8031-5c3c8ce14e0f',
- 'c1b3c1a1-affe-5b60-bf33-814d523bb6e6',
- '19dd5061-c49f-f886-660f-7092fbae9481',
- 'f8c487b4-0585-67f4-e058-58c5a685a1bf',
- 'eb344593-1788-d58f-3577-ce96430c45b2',
- 'eae9edc9-fe87-f5ff-7b79-95050f586754',
- '2d97aeb2-7fd9-775d-97d1-b3c9e9a908d2',
- 'c0b091ae-73f8-5910-93f4-cd2ecf098331',
- '502e4cc1-c0be-c868-0b30-9792a9b29545',
- '6443223d-e591-1468-d536-9c01528eb3fc',
- '67b75f27-3cac-1bb7-052e-d82d0168b1e4',
- 'c2fdfd29-e56e-8534-85bd-5decf485092b',
- '861c7578-9243-636c-0361-1eb3203f8614',
- 'f8d61f6c-dc56-2fb3-bd98-b4776f5786a9',
- '3374ffd8-3e6a-ae37-e6ff-ee16216a55e4',
- '986f5d95-14f4-9362-a64a-e2fcbc9e3be4',
- 'a30d3445-9d4f-7213-b9b7-7ff4bc303c7f',
- '1303453c-5d0e-5f82-ca66-4470d3b47a39',
- '425275d9-920f-10b3-13ee-fd4c06a8b225',
- '93a217fa-dbfd-db38-d624-3ff09bb5cb8c',
- 'ed177858-bb99-a55a-0026-1da437b09965',
- '8dbdf3e8-288f-b81f-c2e5-7fa9ef28fbab',
- 'fdc2310a-b2a8-a3e2-8863-ee9aa74af4f7',
- '9dc4d891-7506-63eb-8b66-2c7faf599ed3',
- '7d622fb8-acfe-d790-2d5c-5a3f46f68ac0',
- '665a8caa-deed-4383-3653-43f1fbdfa4a7',
- 'e649309e-e0aa-65ee-9f2e-56398ef4c862',
- '6f912e59-8be5-4b46-7efa-dc97436d0843',
- '283c7871-ba78-8fba-bebe-043abe73f935',
- 'c84a778e-0de9-64be-c5c4-6d5f23fad5ce',
- 'dc938b0f-c955-74c7-1a44-a801cbbdb90e',
- '935274a8-c0ff-1ab9-f8bc-f50229d1fbc2',
- 'ad91be74-6394-200d-306e-e1d4c875b686',
- '620a10d2-63bd-1d30-d254-553ae40e4c68',
- '1d1b0b8f-744c-a683-e489-86c62287c0e9',
- '3d4131d6-a510-b8c6-c216-13455810c087',
- 'f5f36285-b54f-ee49-b9de-02e21de53a2c',
- 'dcdf4388-e458-556a-ccaa-cedb96ef0255',
- '11660db3-1c2c-a031-e7e0-8eb389b78c8b',
- 'f183872b-75f5-53f8-1fac-ee014d2b1a95',
- '77e0ba7d-b3e6-9130-ab79-4e9f516214aa',
- '94011df4-df48-5ee7-f1a9-72166510eaef',
- '8deadd32-8cb6-26f7-e0be-db0d40e4fbf4',
- '4c0d294a-fa05-69c0-8260-a6994937a02f',
- '9a7f88bc-47cc-5909-4231-86877e409e88',
- 'eec5e406-1e88-f29b-ebda-757c9b58cd81',
- 'b7837b78-f258-335b-8c65-ab8e861cf227',
- 'd5625fb4-ef43-0098-655d-7a7b434211fc',
- '9e31aee7-2567-d83b-3977-39fa46e3abba',
- 'f3badc92-ef4b-2f2a-f10e-5c7dc567f7a5',
- 'e641279f-a06a-216b-1d17-7b2189acaefc',
- '0ec43696-2642-3369-98fb-871e4b675e69',
- '7cb1b056-58c0-cf94-fd6d-cc934ada05fa',
- '88899019-67b0-a67f-4fe2-48433c59b80f',
- '6154fcb5-4dde-a3ee-50f0-199f4d5707f0',
- '097062af-212c-9674-41fb-52f647db60df',
- 'fdfad4a9-f47e-42e9-bd1f-1f39f47b266b',
- '45dde6a2-0421-4a26-9da3-3f52e73a858f',
- '406e87c1-c1fb-4afd-82ed-8286575521eb',
- 'e1376fac-bafc-7ca9-4a7c-a19891919ab7',
- '73634a0d-2d21-4884-949d-b3a6be08df83',
- '8881ce32-fe21-40c3-983b-d221af03dc4e',
- 'f84be44f-6634-4b33-be9c-bc29191817dd',
- 'db081cc9-c44d-40fa-b332-a6eb38ed02fc',
- 'a6d1bb21-00bb-4047-abb1-cf97fdf45585',
- '3576c49b-4fd6-4a7d-a003-0c54ae144bfd',
- '09679723-6f95-4a0f-8882-95ebec55b345',
- '0ab4b27f-5e1e-43ee-8c01-c2fcd4795c09',
- 'e5dec11a-1126-48a7-9bac-3d14b399e149',
- '8e805e6d-702c-7383-1448-e8c713264301',
- 'b1495882-aa85-46e2-969e-6b4d5613994a',
- '5c1e53a0-b32e-418b-96f7-a8569c044d17',
- 'bb7d3f4b-926a-4725-8e5e-8b16b031b1b8',
- 'f7845ee5-eaa1-47ad-bca3-0aefe063051c',
- 'df9c6569-3c56-4fbf-84c5-c55e83b3e620',
- 'fe770b15-238e-4510-8896-5f86d4dafa17',
- 'eba105f8-0f34-eb7f-2492-9d31ccd46a28',
- 'e2645cc8-1ec7-4e1a-9251-e681d4709a1f',
- '95b97476-c1a4-499e-86f8-6edf6e3ad10d',
- 'defe9999-13df-46ce-8f2e-d769b92c4c8a',
- '44f48e39-4dc6-4b4d-9b09-8a79455c4519',
- '8d4048d3-19f6-3175-fef9-9ead7ace262b',
- '32953674-1ffd-810e-aa91-4b1c7c0f352a',
- 'cba4cdf4-20fd-
- 47f0-99f4-49c2e44e32c4',
- '73d4fd46-a16b-492a-a67e-e73d737eaf70',
- 'fef7fd0b-dc61-faa5-68bf-3dc96b08f23e',
- '301a30d2-9533-39d9-4a7a-45f4fe135444',
- 'c68a2b19-34db-5713-f5a3-0c089e4ff65c',
- '1298da0e-76e2-22ed-c0fd-8099c677b4d6',
- 'baa01f70-4a44-2d21-dccf-89d6b74d7332',
- '70b8d3c3-8198-2e66-415f-cb3e617a20f6',
- '3169c36c-5002-b8df-3595-095d4b2992cd',
- 'f2ef816e-cf6a-22ee-987f-d4c1449a2935',
- '0ad1d263-e8f0-93ec-70e1-b4694ab35689',
- 'cd7535a6-ea06-67f4-baeb-904b2b8ec9ef',
- '85c2bd76-eef8-0462-41a2-c4338874a260',
- '3e500ad1-df64-e1fe-7f54-a7dd72927308',
- '14f24249-54fe-c150-6742-5c88752353e0',
- '03f31cb9-b6ad-2b0b-b088-eaf14fa2c612',
- 'bc8c84b3-3396-0b5c-172f-03106ccc4e5a',
- '821f8721-0775-5497-5db6-9cee5d42e3d9',
- 'd2de9687-5a68-dfc9-b2dd-bcb5003ff496',
- 'e40a6378-2d66-55d0-3f2d-e25b476211ef',
- '54da4f0a-a229-1515-da79-a6f4a69ad5b3',
- 'c0e50519-73f6-591f-df1b-d6cad3a1ee8c',
- '853d1abe-8512-63ef-fe88-015d8d870539',
- 'c337f386-2fea-5dc8-c4db-600daad999d7',
- '7d30ae54-ae88-19f9-29c2-57ee0c78bcb8',
- '8908e964-3537-e18f-dcbe-70c85c1e9222',
- '4b55609c-648f-cee4-6dad-ec7b7dfd2abc',
- '626353f3-9497-0b4e-cc26-ab3ac96fb355',
- '2cce34d1-e30e-911a-087b-4bab88df13f5',
- '28cc0d7c-11db-1c23-6c22-ac859fab88ba',
- '9b7d5199-e412-5011-797a-88011cb90870',
- 'bf2e6ee0-630e-60c6-ab6a-26ed65dbfbcf',
- 'b591b6d5-cd3f-e449-e7c8-4a55d6a10756',
- '26b2aee1-8d95-6012-19a3-ccb56f80e860',
- '2b5dda66-c31a-0ca6-df49-cb6a428c3bd5',
- '4f8134d9-1633-ef6a-c6d4-3bb19e5ca45b',
- '30bf8ebf-fa25-536c-2b0a-a9305e495bc5',
- 'df92c70e-dbff-2002-29b8-fc9259cdcd5f',
- 'a56ba31e-9e1b-328d-9128-33b375b9c899',
- 'c6c1f30f-57b3-3107-47da-0c58becfaeca',
- '483a7acb-3f6b-60eb-8169-41df2949eec8',
- 'a1730350-3467-4f0d-b141-127e841c8a28',
- 'a759f28e-77b5-4419-6a76-948c5c0c47c2',
- '96ef206a-be50-d167-93c7-25b0808766d4',
- 'edac2f2c-4ef6-f8cb-e844-388e37248c67',
- '675e5a27-d48f-97d8-a302-43cc0423b28a',
- '672f0bbb-c89f-c886-dfa6-e6c86f587fe7',
- '9fa7e3f4-bcc4-ce44-a367-2f005a42e888',
- '26f14e14-c6d9-82bc-a768-d2321501b80c',
- '8e589229-9169-e85e-9ba4-3228904d8e12',
- '850b2b12-0f8e-29d6-f06a-b82747bf307d',
- '24e2a37e-d7fd-c99b-650b-3a31a2321949',
- '62eb85eb-0eb8-962b-f129-43f70c785775',
- 'ed881417-a902-f105-c89a-ee1846a11812',
- '60241719-8c4b-6914-4963-173d29a30e47',
- '60bcebad-9770-bbe6-1202-a1a3befe1290',
- 'ffd02ed1-c44d-5a5e-d729-3863406dc38f',
- '23445cdc-6f8e-1e63-1156-e419dc96acff',
- '40f01b03-d58b-39d3-47e6-5ca4cb30cb49',
- '13672f64-f0cc-18ac-ffa1-f1bb8ae8cd89',
- 'ce79df46-aebe-849c-0d07-f7483656f615',
- 'a7fc9eda-0252-eaf5-0d02-75e54dbd0959',
- '0874dd08-d3b0-5544-df41-ff048857c527',
- 'caa6d44a-7a88-9642-13c8-f28b4b209929',
- '45ef2af3-9f6d-ecfb-bc4e-7711244131ff',
- 'fe804113-1a5b-80da-a13a-728b5e042ac3',
- 'b8d00a0a-8cc5-502c-b0e6-19b2445ea23f',
- '97b0921d-fc95-d733-7c63-98cd1d6d42e2',
- '1d6d7a07-c327-e33a-60d1-a1746f15ad6d',
- '153ae648-82a5-8cd9-4df4-f64fd971b693',
- '385b2cc4-59b3-a32b-eab1-e88f9b34b7a6',
- 'ab8973b0-5ebb-c416-9bfc-9258eb544fba',
- 'cfea91a8-f8fc-2a50-245b-d6b3c24dea28',
- 'eace2c2c-cb2f-99c8-b1c3-adea4795efed',
- '05d94d8a-d49b-ec4b-1028-c7b22ed0c099',
- 'd3c5b6b9-65bd-be7c-6137-40581010fd80',
- '8feffaf7-d0da-c8c8-106f-0533a51b326b',
- 'c68bfa4b-0812-fe52-8f66-0af5f8dcabab',
- '53b784c4-5520-849f-32db-ef982872833d',
- '4a939415-1852-a262-d424-b184ad833935',
- 'c6b19d81-0c49-45a9-acad-1ea41be55e89',
- 'b2c1c1bf-83e6-4132-0e21-edd6343adbc6',
- 'b4ee7fe6-fd12-b25e-981a-7b13cd784036',
- '682576d5-4542-760a-bf5d-81b3c40b499a',
- '07e9aba8-b162-4dc4-6532-dffe2de02f3c',
- '56dbfb9f-a481-830c-2fed-eeec2008b6c6',
- '7a82778a-4bd4-7b0b-9323-7fc7ddcf3ff2',
- '8f598161-99a2-5595-83e1-11d13f3e534a',
- '9718b4e4-4093-59a3-fddd-d20d3ce6cf2d',
- '0719fb07-c3d2-f17c-00d4-dde549deed99',
- '7a0b466d-46d8-2a74-8f52-affd55c5600e',
- '5a720cd6-524a-8570-93a3-13455ec9b162',
- '1ec660ba-3c7d-b352-0b3f-6653f9f86459',
- 'f1419ef0-a756-4d13-0e08-9ea211512d24',
- 'cb2f570a-28b1-cf0c-fba5-9eb917002fa8',
- '0c71af4b-e9cf-7718-565b-c024c296e08a',
- '0e4f4d47-4e38-a522-4012-8659ed0947f3',
- 'eef90515-7292-b91e-2edc-6538e639cff8',
- '92535c67-e578-5b2a-410a-88526fe306c8',
- 'cb6f8d14-d0cc-210a-8a17-122b4645a26c',
- '416dca5a-2012-a33f-adf4-38fec39b58d2',
- '1358bbc8-9dbe-074b-e635-756be0333e19',
- 'eba1305d-ee26-2e5a-e420-07cebe')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement