 | | | ORA-01925: maximum of 30 enabled roles exceeded | ORA-01925: maximum of 30 enabled roles exceeded 2004-02-25 - By Mladen Gogala
Back
Actually, the best thing to do (and that might not be entirely possible in 8i)
is to use FGAC and application contexts instead. That avoids all llimitations
based on roles.
On 02/25/2004 01:37:08 PM, "Jamadagni, Rajendra" wrote:
> Hey, we are pushing 148 and some enquired can we push it higher ...
>
> Raj
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
---
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> select standard_disclaimer from company_requirements;
> QOTD: Any clod can have facts, having an opinion is an art !
>
>
> -- --Original Message-- --
> From: oracle-l-bounce@(protected)
> [mailto:oracle-l-bounce@(protected)]On Behalf Of Powell, Mark D
> Sent: Wednesday, February 25, 2004 1:33 PM
> To: 'oracle-l@(protected)'
> Subject: RE: ORA-01925 (See http://ORA-01925.ora-code.com): maximum of 30 enabled roles exceeded
>
>
> This may not be the best workaround but I believe you can log in with a DBA
> ID and then drop and recreate a couple of the roles attached to SYS because
> they were created under the SYS ID. This does require that you are able to
> re-grant all privileges to the role or that a couple of old and obsolete
> roles exist that you need to clean up anyway.
>
> Problems like this are one reason the SYS ID should not be used to perform
> DBA tasks like creating users, roles, or user objects.
>
>
> -- --Original Message-- --
> From: oracle-l-bounce@(protected)
> [mailto:oracle-l-bounce@(protected)]On Behalf Of Levesque, Roger I. ,
> CTR , WHS/PSD
> Sent: Wednesday, February 25, 2004 1:25 PM
> To: 'oracle-l@(protected)'
> Subject: RE: ORA-01925 (See http://ORA-01925.ora-code.com): maximum of 30 enabled roles exceeded
>
>
> 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 (See http://tch-22.ora-code.com). 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@(protected)]
> Sent: Wednesday, February 25, 2004 12:48 PM
> To: oracle-l@(protected)
> Subject: Re: ORA-01925 (See http://ORA-01925.ora-code.com): 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@(protected)>
> To: <oracle-l@(protected)>
> Sent: Wednesday, February 25, 2004 1:52 PM
> Subject: ORA-01925 (See http://ORA-01925.ora-code.com): maximum of 30 enabled roles exceeded
>
>
> > I get ORA-01925 (See http://ORA-01925.ora-code.com): 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@(protected) put
> > 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://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@(protected) put
> 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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@(protected)
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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@(protected)
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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@(protected)
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://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@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
|