Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
Olivierln
Frequent Visitor

Documentationt - TMSCHEMA_ROLE_MEMBERSHIPS - Value description

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

3 REPLIES 3
eudesmcf
Frequent Visitor

@Olivierln You can see on the Protocol Documentation, all DMVs documentation is describe there.

 

https://learn.microsoft.com/en-us/openspecs/sql_server_protocols/ms-ssas/854a72f2-d637-4be3-b60f-6a4...

 

eudesmcf_0-1723858753669.png

 

If I Help, consider close the question.

Olivierln
Frequent Visitor

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

Olivierln_0-1691752781824.png

 

I would like to get the meaning of the id since this is not documented

 

 

Best Regards

 

Olivier

v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.