Skip to main content

Manage PostgreSQL for 1C users

Users are used to access databases in a PostgreSQL for 1C cluster. To create a database, first create a user.

You can grant access to a single database to multiple users, but there can be only one database owner. You can also revoke access for a user.

You can manage user access permissions to database objects using roles and privileges; learn more in the Configure user roles and privileges in PostgreSQL for 1C instructions.

You can also specify DBMS settings at the user level. Learn more in the Settings for PostgreSQL for 1C instructions.

Database owner

A database owner is a user assigned when creating a database. There can only be one owner, but you can change it. The owner cannot be deleted — every database must have an owner.

You can assign roles and grant privileges to the database owner just like to any other user. Learn more in the Configure user roles and privileges in PostgreSQL for 1C instructions.

Differences between the database owner and other users:

  • ownership of deleted users' objects is transferred to the database owner. After deleting other users, you will not lose access to the objects they created in the database and will be able to manage them via the owner;

  • in PostgreSQL 15 and higher, the database owner owns the public schema and can create objects in it.

By default, the database owner, like other users, does not have access to objects created by other existing users. By default, access to objects is only available to the users who created those objects. To grant access to objects, grant privileges.

Create a user

  1. In the control panel, from the top menu, click Products and select Cloud Databases.

  2. Go to the Active tab.

  3. Go to the cluster page → the Users tab.

  4. Click Create User.

  5. Enter a username.

  6. Enter a user password or click Generate.

  7. Copy and save the user password — it cannot be viewed in the control panel after saving, but you can change it.

  8. Optional: select the preconfigured roles you want to assign to the user. You can change the list of roles after creating the user. Learn more about roles in the Configure user roles and privileges in PostgreSQL for 1C instructions.

  9. Optional: to change the default values of user-level DBMS settings:

    9.1. In the Custom DBMS settings block, click Edit.

    9.2. Specify new values.

    9.3. Click Save.

    You can view user-level DBMS settings or change them after creating the user. Learn more in the Settings for PostgreSQL for 1C instructions.

  10. Click Create.

Change user password

  1. In the control panel, from the top menu, click Products and select Cloud Databases.
  2. Go to the Active tab.
  3. Go to the cluster page → the Users tab.
  4. From the user's menu, select Change password.
  5. Enter a user password or click Generate.
  6. Copy and save the user password — it cannot be viewed in the control panel after saving.
  7. Click Save.
  8. Change the password in your application.

Grant access to a user

You can grant access to a single PostgreSQL for 1C database to multiple users.

  1. In the control panel, from the top menu, click Products and select Cloud Databases.
  2. Go to the Active tab.
  3. Go to the database cluster page → the Databases tab.
  4. In the database card, click .
  5. In the Have access field, select the users.

Change database owner

When changing the database owner, ownership of their objects is not transferred to the new database owner.

  1. In the control panel, from the top menu, click Products and select Cloud Databases.
  2. Go to the Active tab.
  3. Go to the database cluster page → the Databases tab.
  4. In the database card, click .
  5. In the Database owner list, select another owner.

Revoke access for a user

  1. In the control panel, from the top menu, click Products and select Cloud Databases.
  2. Go to the Active tab.
  3. Go to the database cluster page → the Databases tab.
  4. In the database card, click .
  5. In the Have access field, remove the user.