Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.4.3 |  CUBRID 9.0.0 | 

CUBRID Manager User Management Console

The account and password of CUBRID Manager user are used to access the CUBRID Manager server when starting the CUBRID Manager client, distinguishing this user from the database user. CUBRID Manager Administrator (cm_admin) is a CLI tool that manages user information and it executes commands in the console window to manage users.

The following shows how to use the CUBRID Manager (hereafter, CM) Administrator utilities. The utilities can be used through GUI on the CUBRID Manager client.

cm_admin utility_name

utility_name:

  adduser [option] <cmuser-name> <cmuser-password>   --- Adds a CM user

  deluser <cmuser-name>   --- Deletes a CM user

  viewuser [cmuser-name]   --- Displays CM user information

  changeuserauth [option] <cmuser-name>  --- Changes the CM user authority

  changeuserpwd [option] <cmuser-name>  --- Changes the CM user password

  adddbinfo [option] <cmuser-name> <database-name>  --- Adds database information of the CM user

  deldbinfo <cmuser-name> <database-name>  --- Deletes database information of the CM user

  changedbinfo [option] <database-name> number-of-pages  --- Changes database information of the CM user

CM Users

Information about CM users consists of the followings:

  • CM user authority: Includes the following information.
    • The permission to configure broker
    • The permission to create a database. For now, this authority is only given to the admin user.
    • The permission to monitor status
  • Database information: A database that a CM user can use
  • CM user password

The default user authority of CUBRID Manager is admin and its password is admin. Users who has admin authority have full administrative controls.

Adding CM Users
Description

The cm_admin adduser utility creates a CM user who has been granted a specific authority and has database information. The permissions to configure broker, create a database, and monitor status can be granted to the CM user.

Syntax

cm_admin adduser options cmuser-name cmuser-password

options :

[{-b | --broker} authority]

[{-c | --dbcreate} authority]

[{-m | --monitor} authority]

[{-d | --dbinfo} database-info]

  • cm_admin: An integrated utility to manage CUBRID Manager
  • adduser: A command to create a new CM user
  • options: The -b, -c, -m, and -d options are given. For more information, see description and example of each option.
  • cmuser-name: Specifies a unique name to a CM user. The name must have at least 4 characters in length. If the specified name in cmuser-name is identical to the existing one, cm_admin will stop creating a new CM user.
  • cmuser-password: A password of a CM user. The password must have at least 4 characters in length.
Options

Option

Description

-b
--broker

Specifies the broker authority which will be granted to a new CM user.
Options: admin, none (default), and monitor

-c
--dbcreate

Specifies the authority to create a database which will be granted to a new CM user.

Options: none (default) and admin

-m
--monitor

Specifies the authority to monitor status which will be granted to a new CM user.
Options: admin, none (default), and monitor

-d
--dbinfo

Specifies database information of a new CM user.
The format of DBINFO must be "<dbname>;<uid>;<broker_ip>,<broker_port>".

Configuring broker authority (-b)

The following example shows how to create a CM user whose name is testcm and password is testcmpwd and then configure broker authority to monitor

cm_admin adduser -b monitor testcm testcmpwd

Configuring authority to create a database (-c)

The following example shows how to create a CM user whose name is testcm and password is testcmpwd and then configure database creation authority to admin.

cm_admin adduser -c admin testcm testcmpwd

Configuring authority to monitor status (-m)

The following example shows how to create a CM user whose name is testcm and password is testcmpwd and then configure monitoring authority to admin.

cm_admin adduser -m admin testcm testcmpwd

Adding database information (-d)

The following example shows how to add database information "testdb;dba;localhost,30000" to a CM user named testcm.

cm_admin adduser -d "testdb;dba;localhost,30000" testcm testcmpwd

Deleting CM Users
Description

The cm_admin deluser utility deletes a CM user.

Syntax

cm_admin deluser cmuser-name cmuser-password

  • cm_admin: An integrated utility to manage CUBRID Manager
  • deluser: A command to delete an existing CM user
  • cmuser-name: The name of a CM user to be deleted
Example

The following example shows how to delete a CM user named testcm.

cm_admin deluser testcm

Displaying CM User information
Description

The cm_admin viewuser utility displays information of a CM user.

Syntax

cm_admin viewuser cmuser-name

  • cm_admin: An integrated utility to manage CUBRID Manager
  • viewuser: A command to display the CM user information
  • cmuser-name: A CM user name. If this value is entered, information only for the specified user is displayed; if it is omitted, information for all CM users is displayed.
Example

The following example shows how to display information of a CM user named testcm.

cm_admin viewuser testcm

The information will be displayed as follows:

CM USER: testcm

  Auth info:

    broker: none

    dbcreate: none

    statusmonitorauth: none

  DB info:

    ==========================================================================================

     DBNAME                                           UID               BROKER INFO             

    ==========================================================================================

     testdb                                           dba               localhost,30000  

Changing the Authority of CM Users
Description

The cm_admin changeuserauth utility changes the authority of a CM user.

Syntax

cm_admin changeuserauthoptions cmuser-name

options :

[{-b | --broker} authority]

[{-c | --dbcreate} authority]

[{-m | --monitor} authority]

  • cm_admin: An integrated utility to manage CUBRID Manager
  • changeuserauth: A command to change the authority of a CM user
  • options: The -b, -c, and -m options are given. For more information, see description and example of each option.
  • cmuser-name: The name of a CM user whose authority to be changed
Options

Option

Description

-b
--broker

Specifies the broker authority that will be granted to a CM user.
Options: admin, none, and monitor

-c
--dbcreate

Specifies the authority to create a database which will be granted to a CM user.
Options: none, and admin

-m
--monitor

Specifies the authority to monitor status which will be granted to a CM user.
Options: admin, none, and monitor

Configuring broker authority (-b)

The following example shows how to change the broker authority of a CM user named testcm to monitor.

cm_admin changeuserauth -b monitor testcm

Configuring authority to create database (-c)

The following example shows how to change the database creation authority of a CM user named testcm to admin.

cm_admin changeuserauth -c admin testcm

Configuring authority to monitor status (-m)

The following example shows how to change the monitoring authority of a CM user named testcm to admin.

cm_admin changeuserauth -m admin testcm

Changing the CM User Password
Description

The cm_admin changeuserpwd utility changes the password of a CM user.

Syntax

cm_admin changeuserpwd old_pwd new_pwd cmuser-name

old_pwd :

{-o | --oldpass oldpassword } | --adminpass adiminpassword

new_pwd :

{-n | --newpass} newpassword

  • cm_admin: An integrated utility to manage CUBRID Manager
  • changeuserpwd: A command to change the password of a CM user
  • options: The -o, -n, and --adminpass options are given. Either --oldpass or --adminpass option must be used. For more information, see description and example of each option.
  • cmuser-name: The name of a CM user whose password to be changed
Options

Option

Description

-o
--oldpass

Specifies the existing password of a CM user. Either this or --adminpass option must be used.

-n
--newpass

Specifies a new password of a CM user.

--adminpass

Specifies the password of an admin user. Either this or --oldpass option must be used.

Changing the existing password (-o) to a new password (-n)

The following example shows how to change a password of a CM user named testcm. Either --oldpass or --adminpass option must be used.

cm_admin changeuserpwd -o old_password -n new_password testcm

Changing the existing password (-o) to a new password (-n) by using an admin password

The following example shows how to change a password of a CM user named testcm by using an admin password. Either --oldpass or --adminpass option must be used.

cm_admin changeuserauth --adminpass admin_password -n new_password testcm

Adding Database Information to CM Users
Description

The cm_admin adddbinfo utility adds database information (database name, UID, broker IP, and broker port) to a CM user.

Syntax

cm_admin adddbinfo options cmuser-name database-name

options :

[{-u | --uid} userid]

[{-h | --host} broker-ip]

[{-p | --port} broker-port]

  • cm_admin: An integrated utility to manage CUBRID Manager
  • adddbinfo: A command to add database information to a CM user
  • options: The -u, -h, and -p options are given. For more information, see description and example of each option.
  • cmuser-name: CM user name
  • databse-name: The name of a database to be added
Options

Option

Description

-u
--uid

Specifies the ID of a database user.
Default value: dba

-h
--host

Specifies the host of a broker used when clients access a database.
Default value: localhost

-p
--port

Specifies the port number of a broker used when clients access a database.
Default value: 30000

Adding database user ID (-u)

The following example shows how to add a database of which name is testdb and user ID is uid to a CM user named testcm.

cm_admin adddbinfo -u uid testcm testdb

Adding a host IP of a broker (-h)

The following example shows how to add a database of which name is testdb and the host IP is 127.0.0.1 to a CM user named testcm.

cm_admin adddbinfo -h 127.0.0.1 testcm testdb

Adding a broker port (-p)

The following example shows how to add a database of which name is testdb and the broker port 33000 to a CM user named testcm.

cm_admin adddbinfo -p 33000 testcm testdb

Creating a database with a default value

The following example shows how to add a database without specifying any user-defined values to a CM user named testcm.

cm_admin adddbinfo testcm testdb

Deleting database information from CM Users
Description

The cm_admin deldbinfo utility deletes database information of a specified CM user.

Syntax

cm_admin deldbinfo options cmuser-name database-name

  • cm_admin: An integrated utility to manage CUBRID Manager
  • deldbinfo: A command to delete database information of a CM user
  • cmuser-name: CM user name
  • databse-name: The name of a database to be deleted
Example

The following example shows how to delete database information of which name is testdb from a CM user named testcm.

cm_admin deldbinfo  testcm testdb

Changing Database Information of a CM user
Description

The cm_admin changedbinfo utility changes database information of a specified CM user.

Syntax

cm_admin changedbinfo options cmuser-name database-name

options :

[{-u | --uid} userid]

[{-h | --host} broker-ip]

[{-p | --port} broker-port]

  • cm_admin: An integrated utility to manage CUBRID Manager
  • changedbinfo: A command to change database information of a CM user
  • options: The -u, -h, and -p options are given. For more information, see description and example of each option.
  • cmuser-name: CM user name
  • databse-name: The name of a database to be changed
Options

Option

Description

-u
--uid

Specifies the ID of a database user.

-h
--host

Specifies the host of a broker used when clients access a database.

-p
--port

Specifies the port number of a broker used when clients access a database.

Updating database user ID(-u)

The following example shows how to update user ID information to uid in the testdb database which belongs to a CM user named testcm.

cm_admin changedbinfo -u uid testcm testdb

Updating a host IP of a broker (-h)

The following example shows how to update host IP information to 10.34.63.132 in the testdb database which belongs to a CM user named testcm.

cm_admin changedbinfo -h 10.34.63.132 testcm testdb

Updating a broker port (-p)

The following example shows how to update broker port information to 33000 in the testdb database which belongs to a CM user named testcm.

cm_admin changedbinfo -p 33000 testcm testdb