Creating Analytics Controls to Assign Specific Roles to Users

[JPMac]

I refer to the following document.

https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...

From here, I want to create an Analytics to assign a specific Enterprise Role to a user, but it only describes the role deprovisioning.

==deprovisioning roles from user==

select r.ROLE_NAME,u.username as name, rua.ROLEKEY as roleKey,rua.ACCOUNTKEY as acctKey, u.USERKEY as userKey,'Deprovision Role' as 'Default_Action_For_Analytics' from role_user_account rua join user_accounts ua on ua.ACCOUNTKEY=rua.ACCOUNTKEY join users u on u.USERKEY = ua.USERKEY join roles r on r.ROLEKEY = rua.ROLEKEY where r.STATUS=1

==============================

Can someone tell me the query to add a specific role to user?

[AmitM]

Hi @JPMac , it is same tables and joins mostly. The difference is default action :

For Provisioning : 'Provision Access' as Default_Action_For_Analytics'

For De-Provisioning : ,'Deprovision Role' as 'Default_Action_For_Analytics'

Thanks,

Amit

If this answers your query, Please ACCEPT SOLUTION and give KUDOS.

[JPMac]

@AmitM 

In the first place, analytics allowed action has no provisioning role.
Is it not supported to use this in provisioning role?

[AmitM]

Apologies , not sure which part of my brain thought this is for SavRoles 🙂

lets wait if somebody had a similar challenge. Have you tried exploring {{url}}/ECM/{{path}}/addrole call.

Might be best to wait for somebody to guide on Analytic first 

[Manu269 · Accepted solution]

@JPMac we dont have a feature for Provision Role as Allowed Action.

As suggested by @AmitM try exploring {{url}}/ECM/{{path}}/addrole