Help Center/ TaurusDB_TaurusDB for PostgreSQL/ FAQs/ Database Permission/ How Do I Grant the REPLICATION Permission to a TaurusDB for PostgreSQL Database User?
Updated on 2025-11-14 GMT+08:00
View PDF
Share

How Do I Grant the REPLICATION Permission to a TaurusDB for PostgreSQL Database User?

  1. Log in to the database as user root.
  2. Grant the REPLICATION permission to your account and query the pg_roles table to verify that the permission has been granted.

    ALTER USER <user> REPLICATION;

    SELECT * FROM pg_roles;

You can run the commands to grant permissions as user root only when your database kernel version supports root privilege escalation. For details, see Privileges of the root User.

Parent Topic: Database Permission