Originally posted by marist89
No, it is because you have created > 20 roles.
I would not agree completely. Even though you might have MAX_ENABLED_ROLES=20, you can have virtually unlimited number of roles created on the database and yet you still might never encounter that error.
A very precise diagnosis of the rshivagami's problem would be:
By default, when you create a role, that role is automaticaly granted to the creator! In your case your user SYS has created more than 20 roles (many of them vere created during instalation) and all those roles are by default also granted to SYS. But in fact user SYS doesn't actually require any of those roles!
So you can:
a) revoke those roles (some or all of them) from SYS
b) when creating new roles, if the creator doesn't require that role, revoke it from him/her immediately after the creation
c) increase MAX_ENABLED_ROLES
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?