Is there a way to provide admin & security_admin role to the users using rest integration.

Prithvi Ramesh1
Mega Sage

Use Case:

Whenever a user requests access from PROD to DEV for admin or security admin roles, the flow should automatically assign the requested roles to the user.
The setup is already in place and works correctly for other roles.


Issue:

  • For the admin role, the flow creates an empty record — the user and group Fields are not populated.
  • For the security admin role, the flow throws the following error:

Error: Operation Failed
Details: Error during insert of sys_user_grmember (test user)
(Process Automation.19602fa1890b261025214ad7e9572531; line 😎

10 REPLIES 10

@Prithvi Ramesh1 I don't see there any anomaly.. 

Please ensure that the particular user doesn't already have that role, eventually try it for another user is possible...

Also, for user and group management, there are 3 required records:

  • sys_user
    • data about the user
  • sys_user_group
    • data about the group
  • sys_user_grmember
    • relation between the user and the group

According the error, it seems that your flow is inserting to the sys_user_grmember but the role is assigned through sys_user_has_role table.

 

But for the roles it's different 3 tables:

  • sys_user
    • well, this is actually same :)))
  • sys_user_role
    • data about the role
  • sys_user_has_role
    • relation between that user and that role

 

Can you review this? 

 

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */