Yes. What happens is, because I cannot logon to sys, it won't let me make the change which is a kind of catch-22. I am looking for a way around it so I can logon. I am in Oracle 8.1.7.4.0. Thanks -----Original Message----- From: Juan Cachito Reyes Pacheco [mailto:jreyes@xxxxxxxxxxxxxxxx] Sent: Wednesday, February 25, 2004 12:48 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: ORA-01925: maximum of 30 enabled roles exceeded Did you tried to increase the parameter MAX_ENABLED_ROLES = 70 ----- Original Message ----- From: "Levesque, Roger I. , CTR , WHS/PSD" <levesr@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, February 25, 2004 1:52 PM Subject: ORA-01925: maximum of 30 enabled roles exceeded > I get ORA-01925: maximum of 30 enabled roles exceeded when I try to > logon with the sys id. Any ideas?? > > Thanks > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put > 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------