Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Seeking Service Account's Owner's Approval before account creation

yogesh
Regular Contributor III
Regular Contributor III

We have a use case as below:
When a new service account is requested by any user and they select someone else as the service account's owner, then the approval should go first to the Account Owner and then to Account owner's Manager.

We are not able to achieve the first approval, i.e. seeking approval from the service account owner.

Can someone provide some assistance on this? 

Thanks 

1 REPLY 1

rushikeshvartak
All-Star
All-Star

select userkey from users where FIND_IN_SET(users.userkey,(select distinct REPLACE(raa.attribute_value," ","") from request_access_attrs raa , ars_requests ar, request_access ra WHERE ar.REQUESTKEY = ra.REQUESTKEY and ra.REQUEST_ACCESSKEY = raa.REQUEST_ACCESS_KEY and ar.requestkey=${ARSREQUEST.id} and raa.ATTRIBUTE_NAME="USEROWNERKEY"))!=0 union select userkey from usergroup_users where FIND_IN_SET(usergroup_users.user_groupkey,(select distinct REPLACE(raa.attribute_value," ","") from request_access_attrs raa , ars_requests ar, request_access ra WHERE ar.REQUESTKEY = ra.REQUESTKEY and ra.REQUEST_ACCESSKEY = raa.REQUEST_ACCESS_KEY and ar.requestkey=${ARSREQUEST.id} and raa.ATTRIBUTE_NAME="USERGROUPOWNERKEY"))!=0 union select owneruserkey from accountowners where FIND_IN_SET(accountowners.ACCOUNTKEY,(select distinct REPLACE(raa.attribute_value," ","") from request_access_attrs raa , ars_requests ar, request_access ra WHERE ar.REQUESTKEY = ra.REQUESTKEY and ra.REQUEST_ACCESSKEY = raa.REQUEST_ACCESS_KEY and ar.requestkey=${ARSREQUEST.id} and raa.ATTRIBUTE_NAME="ACCOUNTKEY"))!=0


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.