1 Reply Latest reply: Jan 17, 2013 12:28 AM by 966714 RSS

    ORA-28031,But only 111 roles are assigned

    966714
      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