Filter Roles in Role Owner Certifications

[ksadhashiva]

Hello,

Can we filter the roles in role owner certification based on the role assignment type (roles assigned to users only via requests and not via any other method like birthright prov) ?

Thanks,

Karthik

[DaanishJawed]

Hi @ksadhashiva ,

This is currently not supported. Please raise an enhancement in the ideas portal. https://ideas.saviynt.com

This data is stored in role_user_account table where the source is updated as REQUEST. But this is not exposed in Campaign Configs.

Thanks.

[rushikeshvartak]

2024-03-24T21:47:55-04:00-ecm-services.SaviyntCommonUtilityService-http-nio-8080-exec-406-c8br7-ERROR-role_user_account is not mapped [Select count(*) from com.saviynt.ecm.identitywarehouse.domain.Role_Owners ro, com.saviynt.ecm.identitywarehouse.domain.Roles r where ro.rolekey.id=r.id and ro.rolekey.role_name like 'BR-%' and ro.rolekey in (select rua.rolekey from role_user_account rua where rua.source='ZERODAY') ]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: role_user_account is not mapped [Select count(*) from com.saviynt.ecm.identitywarehouse.domain.Role_Owners ro, com.saviynt.ecm.identitywarehouse.domain.Roles r where ro.rolekey.id=r.id and ro.rolekey.role_name like 'BR-%' and ro.rolekey in (select rua.rolekey from role_user_account rua where rua.source='ZERODAY') ]

Query : and ro.rolekey.role_name like 'BR-%' and ro.rolekey in (select rua.rolekey from role_user_account rua where rua.source='ZERODAY') 

[ksadhashiva]

Thanks for your response.

Thanks,

Karthik

[stalluri]

@ksadhashiva 

Here some ideas for the similar asks.
https://ideas.saviynt.com/ideas/EIC-I-5210
https://ideas.saviynt.com/ideas/EIC-I-4995