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
- Open DBeaver and click on "Database" > "Connect to database" in the top menu bar.
- Select "PostgreSQL" as the database type and enter the necessary connection details (e.g. hostname, port, username, password).
- Click "Connect" to establish the connection.
Step 2: Create a new user
- In the DBeaver sidebar, navigate to the "Users" node under the "Security" section.
- Right-click on the "Users" node and select "Create User" from the context menu.
- 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.
- Click "Create" to create the new user.
Step 3: Grant privileges to the new user
- In the DBeaver sidebar, navigate to the "Privileges" node under the "Security" section.
- Right-click on the "Privileges" node and select "Grant Privileges" from the context menu.
- In the "Grant Privileges" dialog box, select the new user you created in Step 2.
- Choose the privileges you want to grant to the new user (e.g. "SELECT", "INSERT", "UPDATE", "DELETE").
- Click "Grant" to grant the privileges to the new user.
Step 4: Verify the new user
- In the DBeaver sidebar, navigate to the "Users" node under the "Security" section.
- Right-click on the new user you created and select "Properties" from the context menu.
- 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.