How to check what role is mapped to user from SSMS for 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.

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