Role Composing Status

[ejeong]

When Role status is in Composing status, please let me know how to query? 

r.status like 'Composing'? 

Also, when version is created by update in role and status is in Composing, we found that birghtrule is not working and role is not visible in ARS as well. can we configure to cancel the version change after certain day automatically if it's not requested for approval ? or send approval automatically when version is created? 

[rushikeshvartak · Accepted solution]

Query to find roles in composing state -

select r.role_name,r.DESCRIPTION, CASE WHEN r.status = 0 THEN 'INACTIVE' WHEN r.status = 1 THEN 'ACTIVE' WHEN r.status = 2 THEN 'COMPOSING' WHEN r.status = 3 THEN 'SENTFORAPPROVAL' WHEN r.status = 4 THEN 'DECOMMISION' WHEN r.status = 5 THEN 'MINING' END AS 'Role Status', CASE WHEN r.roletype = 1 THEN 'Enabler' WHEN r.roletype = 2 THEN 'Transactional' WHEN r.roletype = 3 THEN 'FireFighter' WHEN r.roletype = 4 THEN 'Enterprise' WHEN r.roletype = 5 THEN 'Application' WHEN r.roletype = 6 THEN 'EntitlementBasedRole' END AS 'Role roletype' from roles r where r.status = 2;

Composing State -

whenever there is workflow attached for role management roles creates version & role status will be composing until role modification in progress.

You can escalation block in workflow to auto reject/approve request after certain days to make role back to active & old version.

Role in ARS 

Only role with  1 status i.e. active will be visible in ARS

Birthright 

only active roles will be added to user.