| 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  |