ORA-01031: Insufficient Privileges Error When a User Without the DBA Role Creates a New User from the User Enrollment Wizard

(Doc ID 1628418.1)

Last updated on OCTOBER 16, 2016

Applies to:

Oracle Utilities Work and Asset Management - Version 1.9.0 and later
Information in this document applies to any platform.


In the past, when users did not want DBA privileges assigned to a user, but still wanted the User to have the ability to create new Users/Oracle Users via the User Enrollment Wizard in WAM, the USER PROFILE ADMINISTRATOR responsibility function and the following privileges were sufficient:


Grant create user to <username>;

Grant alter user to <username>;

Grant grant any role to <username>;

Grant select any table to <username>;

Grant create table to <username>;


However, in WAM 1.9.1, the following error is received when a User with these privileges attempts to create a new User from the User Enrollment Wizard:

ORA-01031: Insufficient Privileges





Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms