Timeline for ORA-28031 while attempting to rebuild or drop index
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 2, 2016 at 9:23 | vote | accept | djaustin | ||
| Sep 2, 2016 at 9:23 | comment | added | djaustin | Ah that may have been the issue I didn't know about recursive roles. I reimported without roles as you suggested and it seems to have fixed things. Thanks! | |
| Sep 1, 2016 at 9:27 | comment | added | Andrew Brennan | Also, try using EXCLUDE=ROLE in your import, then add the roles to the created user later. | |
| Sep 1, 2016 at 9:27 | comment | added | Andrew Brennan | Roles can be recursive withing other roles, and these count towards the limit, are you taking that into account? | |
| Sep 1, 2016 at 8:54 | comment | added | djaustin | I have had a look at the dba_role_privs table and the maximum number of roles assigned to any one user is 121 so I don't actually seem to be breaching that limit. | |
| Aug 31, 2016 at 16:35 | history | answered | Andrew Brennan | CC BY-SA 3.0 |