Show TOC

MIN_ROLE_ADMINS OptionLocate this document in the navigation structure

Configures of the minimum number of required administrators for all roles.

Allowed Values

1 – 10

Default

1

Scope

Option can be set at the database (PUBLIC) level only.

Requires the SET ANY SECURITY OPTION system privilege to set this option. Takes effect immediately.

Remarks

This options sets the minimum number of required administrators for all roles. This value applies to the minimum number of role administrators for each role, not the minimum number or role administrators for the total number of roles. When dropping roles or users, this value ensures that you never create a scenario where there are no users and roles left with sufficient system privilege to manage the remaining users and roles.