My Oracle Support Banner

Delete User Functionality Is Not Working (Doc ID 1487870.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Communications EmbeddedMIND - Version 3.5.0 and later
Information in this document applies to any platform.


After the deleting the testuser using "n"o command, it is deleted from eMIND data structures and not deleted from the DB. Now if user is added it is adding in eMIND data structures and giving error in DB saying already existing user.

Steps to reproduce the issue are as shown below.

1. User and group is added as below and db table view is also shown

#username testuser password testuser
User is added successfully
#group testgroup
Group is added successfully


2. Now testuser is added to group testgroup as shown below

#assign testuser to testgroup
User is assigned to group successfully

3. Now delete the user "testuser" which is giving error as below.

#no username testuser
Application error
ERROR: update or delete on table "user" violates foreign key constraint "membership_user_user_fkey" on table "membership"
DETAIL: Key (user)=(testuser) is still referenced from table "membership".
no username testuser

% Error executing command

#show user
#show user
  user, Admin
  password =
  hash =
  membership, Administrators-Admin
  group = Administrators
  user = Admin




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.