|Oracle® Database Reference
11g Release 2 (11.2)
|PDF · Mobi · ePub|
|Range of values||1 to 148|
MAX_ENABLED_ROLESparameter is deprecated. It is retained for backward compatibility only.
Even if valid values are assigned to this parameter, they are ignored. There is no need to explicitly disable the parameter.
MAX_ENABLED_ROLES specifies the maximum number of database roles that users can enable, including roles contained within other roles. The actual number of roles that users can enable is 2 plus the value of
MAX_ENABLED_ROLES, because each user has two additional roles,
PUBLIC and the user's own role.
For example, if
MAX_ENABLED_ROLES is set to
5, then user
HR can have seven roles enabled (the five enabled by