Data Management:Manage PostgreSQL database account permissions

Create a user

1. Log in to DMS 5.0.

2. Log on to the destination database. For more information, see Log on to a database.

3. On the home page, click the database instance in the navigation pane on the left. In the instance list, right-click the destination instance name and click Database Account Management.

4. On the Database Account Management page, click Create Database Account in the upper-left corner.

5. In the window that appears, configure the following parameters.

   1. Click the Basic settings tab and configure the parameters.

      Configuration Item	Description
      User name	Enter the username for the account.
      Password	Enter the logon password.
      Confirm Password	Enter the logon password again.
      Password Expiration Time	Select an expiration time for the password. For example, if you select 00:00 on December 30, 2021, the password expires at that time. This parameter is optional and has no expiration by default.
      Connection Limit	Enter the maximum number of concurrent connections for the account. For example, if you set this parameter to 10, the account can be used to connect to the database from up to 10 clients at the same time. The default value is -1, which indicates no limit.
      Remarks	Enter remarks for the account.

   2. Click the Permissions tab and select the required permissions.

      Permission Type	Description
      Allow Logon	The logon permission. The corresponding SQL commands are LOGIN and NOLOGIN. By default, logon is allowed.
      Allow User Creation	The permission to create database accounts. The corresponding SQL commands are CREATEROLE and NOCREATEROLE. By default, user creation is allowed.
      Allow DB Creation	The permission to create databases. The corresponding SQL commands are CREATEDB and NOCREATEDB. By default, database creation is allowed.

6. Click Confirm.

7. In the Preview SQL Statement window, click Confirm.

   Note

   Database instances in Security Collaboration mode are subject to security rules. If the execution fails, follow the on-screen instructions or contact a DBA or an administrator for confirmation. For more information about how to adjust the rules, see the FAQ section.

Edit or delete an account

Use the edit feature to modify an account's username, password, global permissions, and object permissions.

1. Log in to DMS 5.0.

2. Click a database instance on the right side of the home page. In the instance list, right-click the target instance name and click Database Account Management.

3. Find the destination account and click Edit or Delete.

References

Best practices for RDS for PostgreSQL permission management