| Oracle9i Database Reference Release 2 (9.2) Part Number A96536-02 |
|
|
View PDF |
|
Parameter type |
Integer |
|
Default value |
|
|
Parameter class |
Static |
|
Range of values |
0 to 148 |
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 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, user HR can have seven roles enabled: the five enabled by MAX_ENABLED_ROLES, plus PUBLIC and HR.
| See Also:
Oracle9i Database Administrator's Guide for more information on setting this parameter |