Logins cannot be deleted because they reference modules which

Document ID : KB000088479
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Logins cannot be deleted because they reference modules which
Resolution:

Symptoms

When trying to delete old logins that show no references in Usage window, you get the following error message:

'AwE-5001

Database Query Error

ORA-20076: Cannot delete db login for Master as references exist'

 


 

Cause

Although there is no reference shown in the Usage window, there are still references in place. They can not be seen under the current user but should be visible when logged in as sqloper.

 


 

Resolution

You can try to log in with the SQLOPER user and delete the references shown in the Usage window, or delete it in sqlplus. Please contact Automic support for the statements.