I need to retrieve a list of all data roles and job roles associated with a given privilege.

When querying by privilege name, I want to capture all the corresponding data roles and job roles linked to it.

I attempted using the tables ASE_PRIVILEGE_VL and ASE_PRIV_ROLE_MBR, but they did not return all the roles associated with the privilege. I need to develop a query that captures all the relevant roles.