Re:

From: John Kanagaraj <JKanagaraj_at_mfi.com>
Date: Mon, 08 Jan 2001 09:39:51 -0800
Message-Id: <10735.126005@fatcity.com>

> What is impact of increasing max_enabled_role parameter. I m getting
> error
> max_enabled_role exceeded 20 , is it possible to change it without
> bouncing
> database.

Hi Ajay,

Before changing this (and bouncing the database), can you look at which user wants to exceed the default value of 20. If you are using SYS or SYSTEM to create roles, then these accounts un-necessarily 'collect' these roles since the role gets assigned to the user who creates it as well. Lots of unsuspecting DBAs have been caught by this! You can easily and safely remove such application-related role from these SYS and SYSTEM 'creators'.

John Kanagaraj
http://www.geocities.com/john_sharmila

Disclaimer : The opinions expressed above are my own and do not reflect those of MFI or its associates Received on Mon Jan 08 2001 - 11:39:51 CST