I've created a new thread for making CLUSTER, REFRESH MATERIALIZED VIEW,and REINDEX grantable:
https://postgr.es/m/20221208183707.GA55474%40nathanxps13
-- Nathan BossartAmazon Web Services: https://aws.amazon.com