The value for max_enabled_roles depends on the version of Oracle you are
using and your operating system. We have several databases running on
Novell/Oracle 7.3.4 with 240 roles enabled. Why so many you ask? Well,
that's because we have a weird third-party package that turns all of its
menu items on and off using roles.
Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message
news:935437541.3387.0.pluto.d4ee154e_at_news.demon.nl...
> The maximum seems to be (from experience) 128.
> The purpose is quite clear: you can not enable more than max_enabled_roles
> at a time.
> In the situation I am referring to roles were used in an inappropriate
> manner.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Jimmy <c6635500_at_comp.polyu.edu.hk> wrote in message
> news:37C24FB5.E483D56_at_comp.polyu.edu.hk...
> > Hello all,
> > I want to set the max_enabled_role larger in the initSID.ora. I want
> > to ask, what's the use of this variable? I cannot set it to 200, now I
> > just set it 100. What can I do if I want to set it over 100? Is it
> > possible to do so? I am using Oracle 7.3.3 on Solairs..
> >
> > Thanks,
> > Jimmy
> >
>
>
Received on Mon Aug 23 1999 - 19:30:42 CDT
