Add new use postfres dbeaver

Here are the steps to add a new user in Postgres using DBeaver:

Step 1: Open DBeaver and connect to your Postgres database

  1. Open DBeaver and click on "Database" > "Connect to database" in the top menu bar.
  2. Select "PostgreSQL" as the database type and enter the necessary connection details (e.g. hostname, port, username, password).
  3. Click "Connect" to establish the connection.

Step 2: Create a new user

  1. In the DBeaver sidebar, navigate to the "Users" node under the "Security" section.
  2. Right-click on the "Users" node and select "Create User" from the context menu.
  3. In the "Create User" dialog box, enter the following information:
    • "Username": Enter the name of the new user (e.g. "newuser").
    • "Password": Enter a password for the new user.
    • "Role": Select "Normal" or "Superuser" depending on the level of access you want to grant to the new user.
  4. Click "Create" to create the new user.

Step 3: Grant privileges to the new user

  1. In the DBeaver sidebar, navigate to the "Privileges" node under the "Security" section.
  2. Right-click on the "Privileges" node and select "Grant Privileges" from the context menu.
  3. In the "Grant Privileges" dialog box, select the new user you created in Step 2.
  4. Choose the privileges you want to grant to the new user (e.g. "SELECT", "INSERT", "UPDATE", "DELETE").
  5. Click "Grant" to grant the privileges to the new user.

Step 4: Verify the new user

  1. In the DBeaver sidebar, navigate to the "Users" node under the "Security" section.
  2. Right-click on the new user you created and select "Properties" from the context menu.
  3. Verify that the new user has been created successfully and that the privileges you granted are listed.

That's it! You have now added a new user to your Postgres database using DBeaver.