Originally posted by rshivagami
Hi all,

When I try to login with the SYS username, I get a 'Maximum of 20 Enabled Roles Exceeded'. Is this because the SYS schema has more than 20 roles assigned to it ?

Thanks,
Shiva.
You are using the default value for MAX_ENABLED_ROLES, that is 20. Raise it up a bit, having in mind that you have the Oracle hard limit of 148.

You might be curious, why so strange number like 148, why not 150 for example. Note that MAX_ENABLED_ROLES includes roles contained within other roles.

Each user has two extra roles, PUBLIC and his/hers own role. Thus, if you set MAX_ENABLED_ROLES to 148 you can have at most 150 roles.