Assigning roles PostgreSQL
Managed Service for PostgreSQL lets you create your own roles in PostgreSQL databases, but it doesn't let you access the default roles. A special
mdb_admin role is provided for users who aren't DB owners, but need administrative privileges.
To assign a user role, use the Yandex.Cloud CLI or API: role assignment from a
GRANT request is canceled when the next database operation is performed.
The mdb_admin role
mdb_admin role includes the following privileges:
- Use system role privileges:
- Use subscriptions for logical replication (
CREATE | DROP | ALTER SUBSCRIPTION).
- Use extensions:
- Use extension-specific functions: