OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Number of Role (oracle 10g-sql)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Number of Role [message #571997]

Wed, 05 December 2012 04:56

mahnazzz
Messages: 98
Registered: July 2011
Location: Iran

Member

Hello.
is there restrictions in number of defining role in oracle?

Report message to a moderator

Re: Number of Role [message #571999 is a reply to message #571997]

Wed, 05 December 2012 05:08

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't think so.

Report message to a moderator

Re: Number of Role [message #572006 is a reply to message #571997]

Wed, 05 December 2012 06:00

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no limit in the number of roles that can be created but in the number of roles that can be enabled in a session.
This limit is given by the parameter "max_enabled_roles".

Note that in previous versions when you connect as SYS you enable all defined roles and so if the total number of roles exceeded "max_enabled_roles" then the session failed. This is no more the case now, SYS enables nothing but has all roles enabled...

Note that there are some inconsistencies in this parameter:

SQL> show parameter max_enabled_roles
NAME                                 TYPE        VALUE
------------------------------------ ----------- ----------------------------------------
max_enabled_roles                    integer     150
SQL> alter system set max_enabled_roles=150 scope=spfile;
alter system set max_enabled_roles=150 scope=spfile
*
ERROR at line 1:
ORA-00068: invalid value 150 for parameter max_enabled_roles, must be between 1 and 148

Amazing, isn't it?

Regards
Michel

Report message to a moderator

Previous Topic:	High CPU for inactive session
Next Topic:	Listener.trc size increasing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Mar 01 06:16:41 CST 2026