Re: ORA-01925 maximum of 20 enabled roles exceeded

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 31 Oct 1999 19:39:23 +0800
Message-ID: <381C2A6B.E6A@yahoo.com>

Armen Khachikian wrote:
>
> I was trying to connect the data base through SYS/CHANGE_ON_INSTALL
> password when I got the followin error:
> ORA-01925: maximum of 20 enabled roles exceeded.
>
> I was checking the error description and it was mentioned that I have to
> increase the MAX_ENABLED_ROLES beyond the value of 20.
> Does anybody know how can I increase this value?
>
> Armen

Check the other posts - but also this is probably a side effect of sys getting the roles as they were created.

Check to see if system really needs those roles ...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Oct 31 1999 - 05:39:23 CST