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.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!