Security and roles v5.6
Warning: You are not reading the most recent version of this documentation.
Documentation improvements are made only to the latest version.
As per semantic versioning, PGD minor releases remain backward compatible and may include important bug fixes and enhancements.
We recommend upgrading the latest minor release as soon as possible.
If you want up-to-date information, read the latest PGD documentation.
Documentation improvements are made only to the latest version.
As per semantic versioning, PGD minor releases remain backward compatible and may include important bug fixes and enhancements.
We recommend upgrading the latest minor release as soon as possible.
If you want up-to-date information, read the latest PGD documentation.
EDB Postgres Distributed allows a PGD cluster to be administered without giving access to the stored data by design. It achieves this through the use of roles and controlled access to system objects.
Roles introduces the roles that PGD predefines for controlling access to PGD functionality.
Role management discusses how roles are managed on multi-database nodes and new nodes.
PGD predefined roles details the specific privileges of the PGD roles.
Roles and replication explains how PGD replication interacts with roles and privileges.
Access control explains how tables, functions, catalog objects and triggers interact with PGD roles and Postgres attributes.