Unable to view users assigned to a particular Site Role
Written By
Madhusudan Sharma
How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!
While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.
Legacy Article
You are viewing an article from our legacy "FastTrack"
publication program, made available for informational purposes. Articles
in this program were published without a requirement for independent
editing or verification and are provided"as is" without
guarantee.
Before using any information from this article, independently verify its
suitability for your situation and project.
Issue
-
Unable to view the "Users" tab or section to view the list of users assigned to the particular site role in order to verify & delete unwanted users.
-
Steps: Navigate to Control Panel > Roles > Site Roles and here, no option to view/delete the assigned users to the site roles.
Resolution
- The UI provides no way to view/delete the users directly in the Control Panel > Roles > Site Roles.
- However, to view, which user is assigned to a particular site role, it can be achieved by checking individual users. For this, navigate to Control Panel > Users and Organizations > 'select the user' > Roles > Site Roles. (The user can be removed from that site role by clicking the (x) button)
-
Additionally, an alternate way can be using the Database (by running some SQL queries) that is as follows -
- Find the 'roleId' of the site role in the 'Role_' table.
- Use the 'UserGroupRole' table to find the userId belonging to the site role.
- Now, use the 'User_' table to find out who the user is with the userId.
- To remove the user from the site role, (Navigate to Control Panel --> Users and Organizations --> 'select the user' --> Roles --> under site roles you can find the site role)
- Click on the (x) button to remove the user from the site role.
Did this article resolve your issue ?