Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/13/2022 01:53 AM
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
10/13/2022 02:04 AM
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