This discussion is archived
1 Reply Latest reply: Jan 16, 2013 10:28 PM by 966714 RSS

ORA-28031,But only 111 roles are assigned

966714 Newbie
Currently Being Moderated
Hi Guys,
I understand oracle user can be granted with maximum 150 roles at a time.
I just created new user and assigned 111 roles to that user.

But as soon as i assigned these roles, it is not possible to login with this user anymore.


SQL> show parameter max_enabled_roles

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_enabled_roles integer 150


sqlplus testUser@Test

Enter Password: oracle_4U
ERROR:
ORA-28031: maximum of 148 enabled roles exceeded



However i executed below query using sys user.

select count(*) from dba_role_privs where grantee='testUser'

this return 111 roles.

Thank you very much.
Harsha

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points