Display group members in command line
I noticed on http://www.cubrid.org/intro_cubrid_security how to manage users using Cubrid Manager and also how to create/delete users as well as grant/revoke privileges from command line.
The thing I could not find is how can you display in command line all users or all users from a given group ?
Best regards,
Magdalena
![[Level:5]](http://www.cubrid.org/modules/point/icons/default/5.gif "Rank: 5/30, reputation score 248 (48% completed for the next level)"){kind=icon}
nicola_magdalenaYou can find user information in the table db_user.
db_user schema:
name CHARACTER VARYING(1073741823)
id INTEGER
password db_password
direct_groups SET OF db_user
groups SET OF db_user
authorization db_authorization
triggers SEQUENCE OF object
display all users
SELECT name FROM db_user;
all users from a given group
SELECT name FROM db_user WHERE (SELECT db_user FROM db_user WHERE name=GROUP_NAME) IN direct_groups;
Replace GROUP_NAME by the name of the GROUP for which you wish to list the users.
