
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-04-2020 03:10 AM
Hi all,
I am trying to remove 'admin' role from some users in my personal instance. but when I go to roles -> admin and select a user to delete, the option 'remove user access from table' is greyed out. I tried a few options but I couldn't find out how.
Could you please kindly help me?
Thank you so much.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-04-2020 03:31 AM
HI Oliver,
First check have you impersonated any user or not ...if not then in that case try the below steps
check the Edit button is visible where you are trying to remove the user...if Edit button is visible click on the edit button and remove the user you want to from the available list.
If the above step doesn't help you then simple go to the user profile and go to the Roles tab click on the Edit button and remove the admin role from the list.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-04-2020 03:31 AM
HI Oliver,
First check have you impersonated any user or not ...if not then in that case try the below steps
check the Edit button is visible where you are trying to remove the user...if Edit button is visible click on the edit button and remove the user you want to from the available list.
If the above step doesn't help you then simple go to the user profile and go to the Roles tab click on the Edit button and remove the admin role from the list.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-04-2020 05:53 AM
Hi Rick,
Thank you for your reply. it worked 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-04-2020 03:35 AM
HI,
please follow below steps:-
1. Navigate to the "sys_user_has_role" table.
2. Filter the results down to the username affected.
3. Export the list as an XML file.
4. Using your XML editor of choice, locate the "<inherited>true</inherited>" entry and replace it with "<inherited>false</inherited>".
5. Save the changes and import the XML file back into the sys_user_has_role table.
6. You should now be able to freely delete the roles from the user.
I double-checked to ensure that this caused no obvious errors and confirmed that the user was no longer able to access the applications associated with the removed roles.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-04-2020 04:52 AM
Hi RamS,
Thank you for replying. I have 2 questions.
1, I do not see the option to export the list as an XML file.
2, the use I am trying to remove 'admin' role didn't get this role inherited. it was directly assigned for inherited is false.
Thank you.