Question: Is there a query that will pull the mart users and their permissions and ignore the versions?
Answer: yes, the below query was written for MS SQL server and it should work in another DBMS with minimal editing.
from m9user m9u,
where m9pa.UserId = m9u.userid
and m9pa.P_Id = m9p.P_Id
and m9c.C_Id = m9pa.C_Id
and m9c.C_Type IN ('M','D','L')
order by 1