Query editor
-- Active OZ AccessControl role grants on Ethereum mainnet.-- Filtered to (a) the 15 rug-relevant role hashes and (b) the last 4 years.-- Source of truth: discovery/dune_query.sql in the opsec-analytics repo.WITH events AS (SELECTcontract_address AS contract,topic1 AS role,CONCAT('0x', SUBSTR(CAST(topic2 AS VARCHAR), -40)) AS account,topic0,block_timeFROM ethereum.logsWHERE block_time >= TIMESTAMP '2022-05-08'AND topic0 IN (0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d,0xf6391f5c32d9c69d2a47ea670b442974b53935d1edc7fd64eb21e047a839171b)AND topic1 IN (0x0000000000000000000000000000000000000000000000000000000000000000,0x189ab7a9244df0848122154315af71fe140f3db0fe014031783b0946b8c9d2e3,0x241ecf16d79d0f8dbfb92cbc07fe17840425976cf0667f022fe9877caa831b08,0x3496e2e73c4d42b75d702e60d9e48102720b8691234415963a5a857b86425d07,0x3c11d16cbaffd01df69ce1c404f6340ee057498f5f00246190ea54220576a848,0x5f58e3a2316349923ce3780f8d587db2d72378aed66a8261c916544fa6846ca5,0x65d7a28e3265b37a6474929f336521b332c1681b933f6cb9f3376673440d862a,0x7935bd0ae54bc31f548c14dba4d37c5c64b3f8ca900cb468fb8abd54d5894f55,0x97667070c54ef182b0f5858b034beac1b6f3089aa2d3188bb1e8929f4fa9b929,0x9f2df0fed2c77648de5860a4cc508cd0818c85b8b8a1ab4ceeef8d981c8956a6,0xb09aa5aeb3702cfd50b6b62bc4532604938f21248a27a1d5ca736082b6819cc1,0xb19546dff01e856fb3f010c267a7b1c60363cf8a4664e21cc89c26224620214e,0xd8aa0f3194971a2a116679f7c2090f6939c8d4e01a2a8d7e41d55e5351469e63,0xfbd454f36a7e1a388bd6fc3ab10d434aa4578f811acbbcf33afb1c697486313c,0xfd643c72710c63c0180259aba6b2d05451e3591a24e58b62239378085726f783))SELECTcontract,CAST(role AS VARCHAR) AS role,account,count_if(topic0 = 0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d) AS granted,count_if(topic0 = 0xf6391f5c32d9c69d2a47ea670b442974b53935d1edc7fd64eb21e047a839171b) AS revoked,MAX(block_time) AS last_event_timeFROM eventsGROUP BY contract, role, accountHAVING count_if(topic0 = 0x2f8788117e7eff1d82e926ec794901d17c78024a50270940304540a733656f0d) >count_if(topic0 = 0xf6391f5c32d9c69d2a47ea670b442974b53935d1edc7fd64eb21e047a839171b)