MAX_ENABLED_ROLES

Property	Description
Parameter type	Integer
Default value	30
Modifiable	No
Range of values	0 to 148
Basic	No

Note:

1. The MAX_ENABLED_ROLES 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).

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter where upper(name) = ‘MAX_ENABLED_ROLES’;

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
max_enabled_roles	150	TRUE	FALSE	FALSE	FALSE	TRUE	max number of roles a user can have enabled

Oracle initializatoin parameters