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 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…