Updated on 2024-11-29 GMT+08:00

Modifying a User's System Permissions

Change the system permissions of a user.

Procedure

  1. Log in to FusionInsight Manager, choose Cluster > Services > MOTService, click Instance, and view and record the service IP address of the MOTServer(Active) instance.
  2. Log in to the active MOTService node as user omm and run the following command to start environment variables:

    source ${MOTSERVER_HOME}/.motservice_profile

  3. Run the following command to connect to the MOTService database and enter the password of user omm:

    gsql -d postgres -p 20105

    Contact the system administrator to obtain the password of user omm for the MOTService database.

  4. Modify the user's system permissions.

    For example, to modify the system permissions of the user joe, run the following command to add the system permission for creating roles and remove the system permission for creating databases:

    ALTER USER joe WITH NOCREATEDB CREATEROLE PASSWORD "joe_password";

    If the following information is displayed, the system permissions are modified:

    ALTER ROLE