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 |