How to check what role is mapped to user from SSMS for lifetime

Back to Forums

Pavani Puvvada

Solved

Question

Roles

Lifetime

Hi,

I am trying to check what role is mapped to user from SQL Server management Studio for lifetime.

In lifetime, we have two roles Administrator and Developer. when I am checking in Database I could not find these roles in Roles table.

Can any one help me where can I check these roles and what tables to checked to get what role is mapped to user

Thanks,

Pavani.

15 Jul 2019

Kilian Hekhuis

MVP

Solution

Hi Pavani,

It's in the OSLTM_INFRASTRUCTUREROLE table. Note that you need to access the right database, as LifeTime typically has it's own database (and perhaps even database server).

15 Jul 2019

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines