Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


1
(click on this box to dismiss)

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

link comment (0) accepted answer
asked 3 years ago
nicola_magdalena
248
1 Answer
1

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 3 years ago
eusto
204
tagged




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



Internet Explorer: Mozilla Firefox: Google Chrome: