Script to find role assigned to the user in snowflake

select GRANTEE_NAME AS "USERNAME", ROLE

from SNOWFLAKE.ACCOUNT_USAGE.GRANTS_TO_USERS

where DELETED_ON is null and Role = 'ROLENAME'

and Grantee_name like '%username%'

order by USERNAME;