Create Database User

Function Description

Use to add a new database user to the database.

At present, the functional support is described as follows:

  • Only superusers have Creation Permissions.
  • Only PostGIS, YukonDatabase-type Datasource are supported.

Starting with SuperMap iDesktopX 11i (2024), the Create Database User feature is available.

Operating instructions

  1. Select the Manage..-> Create Database User button in the opened DatasourceContext Menu. Or choose Toolbox, Data Management, Database Management, Create Database User.
  2. On the pop-up Create Database User dialog, set the following information:
    • Datasource Connection Info: used to verify whether the user has the right to create a user. Set the information of connecting to the Database-type Datasource through the setting button on the right. For details, please refer to the Open Database Datasource.
    • user name: Specifies the name of the new database user. Database users are named as follows:
      • The user name is unique and cannot be duplicated.
      • It is recommended to use letters, data and underscores for naming. PostgresSQL series databases support Chinese naming.
      • The letters Case Sensitive, such as "USER" and "user", are recognized as two user names;
        • Some special user names are reserved in the
      • database, and postgres and PG _ * should be avoided for ordinary user names.
      • The user name cannot be longer than 64 characters.

    • Password: Specifies the login password for the new database user. Required if the database kernel is GaussDB. For openGauss and GaussDB databases, Password Settings must comply with the following rules:

      • The password must contain at least three types of characters: uppercase letters (A-Z), lowercase letters (a-z), numbers (0-9), and special characters (~! @ # $% ^ & & * ()-_ + = | { };:.?/).

      • The password length is not less than 8 characters.

  3. Click the Run button to complete the creation of the database user.

Related topics

Overview of Database User Management

Create and Manage Roles

Data source Permissions Management

Dataset permissions management