Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-04 |
|
|
PDF · Mobi · ePub |
Property | Description |
---|---|
Parameter type | Integer |
Default value | 30 |
Modifiable | No |
Range of values | 0 to 148 |
Basic | No |
Note:
This parameter is deprecated. It is retained for backward compatibility only.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 MAX_ENABLED_ROLES
, plus PUBLIC
and HR
).