My Oracle Support Banner

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 MARCH 19, 2018

Applies to:

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

Symptoms

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

 

Changes

 


Cause

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
Symptoms
Changes
Cause
Solution
References


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