Home » RDBMS Server » Server Administration » Number of Role (oracle 10g-sql)
Number of Role [message #571997] Wed, 05 December 2012 04:56 Go to next message
Messages: 98
Registered: July 2011
Location: Iran
is there restrictions in number of defining role in oracle?
Re: Number of Role [message #571999 is a reply to message #571997] Wed, 05 December 2012 05:08 Go to previous messageGo to next message
Messages: 21691
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't think so.
Re: Number of Role [message #572006 is a reply to message #571997] Wed, 05 December 2012 06:00 Go to previous message
Michel Cadot
Messages: 68045
Registered: March 2007
Location: Nanterre, France, http://...
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?

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

Current Time: Sat Dec 04 17:20:59 CST 2021