- 3528 Views
- 2 replies
- 0 kudos
How list all USERs FROM a especific GROUP USING SQL?
I want to list, using sql editor, all users name from a specific group.Reading documentation, I only learned how to show the groups or the users, using simples filters, like:SHOW GROUPS LIKE '*XPTO*';SHOW GROUPS WITH USER `test@gmail.com`SHOW USERS L...
- 3528 Views
- 2 replies
- 0 kudos
Latest Reply
- 0 kudos
Hi @Sardenberg, To retrieve a list of users from a specific group using SQL, you can follow these steps: Assumptions: Let’s assume you have three tables: USERS, GROUPS, and GROUP_USERS.The USERS table contains user information.The GROUPS table con...
- 0 kudos