Default Roles And A Caution in oracle docs

Hi ,

In oracle 9i, admin. guide in chapter 25 a caution is mentioned: It is on the topic of Specifying Default Roles

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/privs.htm
"

Caution:
When you create a role (other than a user role), it is granted to you implicitly and added as a default role. You receive an error at login if you have more than MAX_ENABLED_ROLES. You can avoid this error by altering the user's default roles to be less than MAX_ENABLED_ROLES. Thus, you should change the DEFAULT ROLE settings of SYS and SYSTEM before creating user roles.
"

I am clear about the caution-what it means. why should default role settings of sys & system be changed? what I understood was that we should see that default roles of a user does not exceed MAX_ENABLED_ROLES , that's it.

Can you pl. help me understand?

N. Received on Tue Aug 09 2005 - 07:26:29 CDT