Setting the Minimum Number of Role Administrators

Set the minimum number of role administrators required to manage each role.

Prerequisites
Requires the SET ANY SECURITY OPTION system privilege to set this option.
Task

The minimum number of role administrators is a configurable database option that you can set to any integer between 1 (the default) and 10. You cannot change this value if so doing results in the number of role administrators for any single role not meeting the new minimum value. You also cannot set this option temporarily.

This value applies to each role, not all roles in total. For example, if there are 20 roles and the minimum number of role administrators is set to two, each of the 20 roles must have a minimum of two role administrators defined, not two role administrators defined to administer the 20 roles in total.

To change the minimum number of role administrators, execute:
SET OPTION Public.min_role_admins = value
Related concepts
Automatic Unlocking of User Accounts
Related reference
MIN_ROLE_ADMINS Option