SQL command limits
Written by
Updated at December 11, 2023
Managed Service for PostgreSQL has some limitations on DB owner actions when using SQL commands:
- You cannot change the PostgreSQL settings.
- You cannot manage users or create and assign roles to them. However, you can grant user privileges at the level of individual DB objects.
- You cannot create databases. However, DB owners and users with the
mdb_admin
role can run theALTER DATABASE
command for a previously created DB. - You cannot manage PostgreSQL extensions.
- No actions that require superuser privileges are allowed.
You can, however, perform all these actions using the Yandex Cloud tools. To learn how, check out our step-by-step guides.