Is there a way to provide admin & security_admin role to the users using rest integration.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2025 01:58 AM
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 😎
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2025 08:13 AM
@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! */