5.25. Instance Roles #

Instance roles provide information about database roles within an instance and are based on the pg_roles view.

To view instance roles:

  1. In the navigation panel, go to InfrastructureInstances.

  2. Click the name of the instance.

  3. In the navigation panel, go to Roles.

  4. (Optional) To display system instance roles, turn on Show system roles.

The table of instance roles includes the following columns:

  • Role: The name of the instance role.

  • Login: Specifies whether the instance role has the LOGIN privilege.

  • Create role: Specifies whether the instance role has the CREATEROLE privilege.

  • Superuser: Specifies whether the instance role has the SUPERUSER privilege.

  • Create DB: Specifies whether the instance role has the CREATEDB privilege.

  • Inheritance of privileges: Specifies whether the instance role automatically inherits privileges of the instance roles it is a member of.

  • Replication: Specifies whether the instance role is a replication instance role. Such roles can initiate replication connections and create and drop replication slots.

  • Bypass RLS: Specifies whether the instance role bypasses row level security policies.

    For more information, refer to the official Postgres Pro documentation on row security policies.

  • Connection limit: The maximum number of concurrent connections this instance role can make. Applies to roles that can connect to the server.

  • Valid until: The password expiration time. Only used for password authentication.

  • Member_of: The instance roles that include this role as a member.

  • Include roles: The instance roles that are members of this role.