and more in a single search tool across platforms. Read the announcement here. |
03/04/2024 02:46 AM
I refer to the following document.
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?
Solved! Go to Solution.
03/04/2024 03:53 AM
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.
03/04/2024 04:35 AM
In the first place, analytics allowed action has no provisioning role.
Is it not supported to use this in provisioning role?
03/04/2024 04:46 AM - edited 03/04/2024 04:48 AM
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
03/04/2024 09:59 PM