Re: too many enabled roles for sys

MAX_ENABLED_ROLES = 999????
I cannnot set even over 150 (Oracle 7.3.3). I don't know the upper limit of Oracle 8 (or Oracle 8i) but I remember that some Oracle admin. books said the limit is below 150....
David
In article <951415471.614509_at_ipt2.iptelecom.net.ua>, "Vitalij Serdakovskij" <wit_at_iptelecom.net.ua> wrote:
> 1. MAX_ENABLED_ROLES is parameter you can specify in init.ora file.
 The
> syntax is:
> MAX_ENABLED_ROLES=999
>
> 2. (Not sure)Connect as internal and revoke unnecessary role from sys.
>
> 3. Create user xophe and stop using sys account.
>
> Good luck!
>
> <Xophe_at_gmx.de> ???????/???????? ? ???????? ?????????:
> news:38B54B58.A5583425_at_gmx.de...
> > Hello,
> >
> > I have a problem with my sys-account. I cannot log on as sys
 anymore.
> > Error message is 'too many enabled roles'.
> > I figured out that this comes from when I set up some roles. I read
> > in the online documentation that sys gets by default all roles that
> > I create and that I should have turned that off before creating the
> > roles.
> > What I didn't find is how to change it back, if once made wrong?
> > Can I somehow disable roles for sys?
> > Where do I define the parameter MAX_ENABLED_ROLES?
> >
> > I'm using Oracle8 under WinNT.
> >
> > Many thanks for any help, hints on this!!!
> >
> > Gudrun
> >
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Mar 19 2000 - 00:00:00 CST