Setting the Minimum Number of Role Administrators

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

Prerequisites
SET ANY SECURITY OPTION system privilege.
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 temporarily set this option.

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 2, each of the 20 roles must have a minimum of 2 role administrators defined, not 2 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