Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi Community,
I working on automatic documentation using DMV (such as Data Marc and Data gods did), and working on the role part, there is something I am wondering :
On the TMSCHEMA_ROLE_MEMBERSHIPS tables, what is the meaning of MemberType. Most of the time the value is 3.... but i do not know the meaning.
The official documentation does not go deep into this subject : MemberType meaning role membsehsips
Does any one know ?
Best
MemberType
@Olivierln You can see on the Protocol Documentation, all DMVs documentation is describe there.
If I Help, consider close the question.
Hi,
when querying the schema with the following sql
= AnalysisServices.Database(
Server,
DBName,
[
Query
= "Select [ID], [RoleID], [MemberName], [MemberID], IdentityProvider, MemberType, ModifiedTime from $SYSTEM.TMSCHEMA_ROLE_MEMBERSHIPS"
]
)
On the column MemberType, i do have an integer as a result
I would like to get the meaning of the id since this is not documented
Best Regards
Olivier
Hi @Olivierln,
Since I'm not so familiar with DMV, can you please share some more detail information about these? They should help us clarify your scenario and test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
User | Count |
---|---|
10 | |
4 | |
4 | |
3 | |
3 |