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.
select m9u.username,
m9pa.C_Id,
m9c.C_Name,
m9pa.P_Id,
m9p.P_Name
from m9user m9u,
m9profileassignment m9pa,
m9profile m9p,
m9catalog m9c
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
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center