Learn the reason and how to get to the bottom of the ORA-01918 error message in Oracle.
When you encounter an ORA-01918 error, the following error message will appear:
ORA-01918: user name does not exist
You tried to execute a command that precise a consumer identify or role identify that does now not exist.
The option(s) to resolve this Oracle error are:
Correct the command and re-execute.
To view a listing of all users, execute the following statement:
SELECT * FROM ALL_USERS;
To view a checklist of all roles, execute the following statement:
SELECT * FROM DBA_ROLES;