When creating an enterprise Postgres database, the SDE user currently requires superuser privileges. As the Postgres documentation indicates, it is a dangerous level of privileges. Moreover, when using modern cloud-hosted or managed services (e.g. Azure Flexible Server for Postgres), database administrators may not be able to grant (or may not have themselves) such elevated permissions.
It would be great to have tools that allow for the SDE setup to be created without superuser privileges. Not only does it better secure the systems by adhering to principle of least privilege, but it also allows the use of newer database versions and features in cloud-hosted environments.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.