Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

(click on this box to dismiss)

Display group members in command line

I noticed on 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,


link comment (0) accepted answer
asked 6 years ago
1 Answer

You 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.

link comment (3)
answered 6 years ago

You are either using a very old browser or a browser that is not supported.
In order to browse you need to have one of the following browsers:

Internet Explorer: Mozilla Firefox: Google Chrome: