Assigning roles PostgreSQL
Managed Service for PostgreSQL doesn't let you access default roles. Instead, it provides special roles:
mdb_admin: For users who aren't database owners, but need administrative privileges.
mdb_replication: For users who need logical replication.
To assign a user a role, use the Yandex.Cloud CLI or API: role assignment from a
GRANT query is canceled when the next database operation is performed.
mdb_admin role includes the following privileges:
- System role privileges:
Learn more about system role in PostgreSQL documentation.
- Subscription for logical replication (
CREATE | DROP | ALTER SUBSCRIPTION).
- Extension-specific functions:
mdb_replication role includes the following privileges:
- Connecting to a cluster using the logical replication protocol (
- Using the replication function: