My Oracle Support Banner

Actions --> Create New User Fails With ORA-01031 After Application of AERS iPatch (Doc ID 1084496.1)

Last updated on JUNE 07, 2010

Applies to:

Adverse Event Reporting System - Version: 4.6.2 to 4.6.2 - Release: 4.6 to 4.6
Information in this document applies to any platform.



When attempting to create a new user via Actions --> Create New User, the following error is being returned after application of iPatch AERS

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_SYS_SQL", line 909
ORA-06512: at "SYS.DBMS_SQL", line 39

The issue can be reproduced at will with the following steps:
1. Log into AERS
2. Click on the Admin console link
3. Click on selected user group
4. Select Actions --> Create New User
5. Click on Create User


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.