| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: MAX_ROLES_ENABLED =
Thomas Kyte wrote:
>
> A copy of this was sent to "Canmor" <canmor_at_micron.net>
> (if that email address didn't require changing)
> On Sun, 19 Sep 1999 00:33:21 -0600, you wrote:
>
> >Hi Folks,
> >
> >I have oracle 8i installed on D:\Ora8iHome. I have a clean bootup.
> >When I login as sys/change_on_install, I get the follwoing message.
> >"Maximum of 20 enabled roles exceeded".
> >
> >Once I added MAX_ROLES_ENABLED = 25 to
> >init.ora, I couldn't login at all. I get "Oracle not availabe".
> >I check the services. Everything seems started.
> >When I removed the line and rebooted, I was able to login
> >again except as sys/change_on_install user.
> >
> >Any tips as to where to add this line or how to get around it,
> >would be appreciated.
> >
>
> all non default roles are granted to sys by default.
>
> you must have >20 default roles.
>
> sys fails upon logging in due to this. To increase add:
>
> max_enabled_roles = 100
>
> or some number (NOT max_roles_enabled).
>
> the database failed to start with this invalid parameter (hence Oracle not
> available). removing it fixed the startup error but not the sys error.
>
> >Thanks
> >
> >Lahcen
> >
>
> --
> See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
> Current article is "Part I of V, Autonomous Transactions" updated June 21'st
>
> Thomas Kyte tkyte_at_us.oracle.com
> Oracle Service Industries Reston, VA USA
>
> Opinions are mine and do not necessarily reflect those of Oracle Corporation
Hello Thomas,
As a general question, is there any known performance degradation with having a 'large' number of roles enabled for a given session, for example, if someone connects with (say) 100 roles all enabled, then will typical execution of queries be slowed by the checking of privs etc etc
Cheers
Connor
--
"Some days you're the pigeon, and some days you're the statue." Received on Sun Sep 19 1999 - 07:04:46 CDT
 |
 |