Andrew Connell

What user is in what role in MCMS?

The MCMS PAPI doesn’t provide the functionality to view what users are in what roles or even if a user is in a specific role. This is something that has caused me frustration in the past. Well, Chester has found a way around it: MCMS API doesn't provide any way to get the user groups (role relevant) for channels/postings. It may be useful in certain places if we can get the people who have which rights. Also no way that we can distinct a Moderator and Editor. So I thought of writing a class library which can be used for this purpose. However, if you’re going to do this, you need to keep one very important thing in mind: if you directly access the MCMS database, you are essentially voiding your warranty & any future calls to Microsoft Support will be fruitless as they will not assist with any issues if you may encounter. Stefan Goßner has mentioned it before, but it’s worth pointing to a recent post he made reguarding this. Maybe you could setup replication of the MCMS database to another database and access the secondary one? I’m not saying that’s supported, but you ~technically~ wouldn’t be accessing...

The MCMS 2002 PAPI doesn’t provide the functionality to view what users are in what roles or even if a user is in a specific role. This is something that has caused me frustration in the past.

Well, Chester has found a way around it:

MCMS API doesn’t provide any way to get the user groups (role relevant) for channels/postings. It may be useful in certain places if we can get the people who have which rights. Also no way that we can distinct a Moderator and Editor. So I thought of writing a class library which can be used for this purpose.

However, if you’re going to do this, you need to keep one very important thing in mind: if you directly access the MCMS database, you are essentially voiding your warranty & any future calls to Microsoft Support will be fruitless as they will not assist with any issues if you may encounter. Stefan Goßner has mentioned it before, but it’s worth pointing to a recent post he made reguarding this.

Maybe you could setup replication of the MCMS database to another database and access the secondary one? I’m not saying that’s supported, but you ~technically~ wouldn’t be accessing the MCMS database in question if you had an issue. This is a definate work around… and I’m not suggesting you should do it. Just put my thinking cap on when I stepped out of the box. Then again, maybe you don’t care…

» MCMS User Roles » CodeProject: MCMS User Roles (code download & sample project)

Andrew Connell
Founder & Chief Course Artisan, Voitanos LLC. | Microsoft MVP
Written by Andrew Connell

Andrew Connell is a web developer with a focus on Microsoft Azure & Microsoft 365. He’s received Microsoft’s MVP award every year since 2005 and has helped thousands of developers through the various courses he’s authored & taught. Andrew’s the founder of Voitanos and is dedicated to delivering industry-leading on-demand video training to professional developers. He lives with his wife & two kids in Florida.